Very complex query (is it possible)

Databases
1

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

2 
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
3

Amazing …
thank u thank u thank u thaaaaaaaaaaaaaaaaaank u