Hi every body ,

I want to ask you if this case is possible, and how can I do it

I have 2 tables the

id, city, and user_name,......

id, user_name, Service_name

each customer have only one service ( relation is one to one )

how can I get this result:
Service_name, Count of customers that have this service for each city

service name --count of users whom using this service in all cities-- city name--count of users whom using this service in each city

example of the result
service name -- total of user -- city1 -- city 2 -- city 3
washing -- 20 --10 -- 3 -- 7
cleaning -- 12 --3 -- 2 -- 7