Hi guys!

I have a table with the next rows:

field1 field2
Site A Cell 101
Site A Cell 101
Site A Cell 102
Site A Cell 102
Site A Cell 103
Site A Cell 104
Site B Cell 201
Site B Cell 201
Site B Cell 205


well, I am locking for sql statment that produces the next dataset result:
Site Cells_Working
Site A 4
Site B 2

I'am trying with :
Select field1 as site,count(field2) as Cells_working from mytable group by; field1
but it doesn´t work
Thanks in advance
martin Alcaraz
malcaraz@rtn.uson.mx