very complex query (is it possible)

[ruba]

Hi every body ,

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

I have 2 tables the

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


services
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

[r937]

SELECT s.service_name
     , c.city
     , COUNT(*) as customers
  FROM services AS s
INNER
  JOIN customer AS c
    ON c.user_name = s.user_name
GROUP
    BY s.service_name
     , c.city

[ruba]

Amazing ..
thank u thank u thank u thaaaaaaaaaaaaaaaaaank u