hello

i have a table like this :

id , city , type
1 NY X
2 NY X
3 NY Y
4 LA X
5 LA Y
6 LA Y
7 LA Y
8 LA Y
9 BA X
9 BA Y

i need to build a quary that will return the type group by city

city X Y
NY 2 1
LA 1 4
BA 1 1

i cannot find how to build this quary

can anuone help me ?

i there.. i see a little problem with the query you are trying to build.. what if you have more variables (like X, Y, Z, W)...if that posible???

HTH

Gonzalo

it dosent metter, I need to return only the count for X or Y

Select
       city,
       count (case type = 'X' then 1 else null end) as X,
       count (case type = 'Y' then 1 else null end) as Y
from table 1
group by city

something like this should work