Problem with create a query on a table

[fekrinejat]

Hi
there is a table with these fields :

1- Name
2- City (contains cities name)
3- Marital Status (contains: Single - Married - Divorced)

Now what would be my Query for counting
each status in each specific city ?


for example i need this result:

City A ----> Single = 20
City A ----> Married = 40
City A ----> Divorced = 10
City B ----> Single = 27
City B ----> Married = 46
City B ----> Divorced = 5
.
.
.
Thanks in advance

[orange]

What have you tried? What result?

[fekrinejat]

I would like to know, how many people in each city has what situation ?

for example :

I expect the result just tells me in City "A" there are 20 People who are single and in City "B" there are 46 people who are married and etc ..

I can use GroupBy to get for example : there are 100 people in city "A" but i cann't separate them by their situations as well ...

A simple question
any idea ?

[orange]

Something like

SELECT City, MartialStatus, Count(Name)
FROM YourTableName
Group By City,MaritalStatus

Try it see if we're close.

[fekrinejat]

Thanks , that helped ..

[orange]

Did you get results?

[fekrinejat]

Yes indeed i did , had told you a simple question for you ..
Thanks anyway