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