Database: cre_Drama_Workshop_Groups
Question: Show all cities along with the number of drama workshop groups in each city.
SQL:
SELECT T1.City_Town ,  count(*) FROM Addresses AS T1 JOIN Drama_Workshop_Groups AS T2 ON T1.Address_ID  =  T2.Address_ID GROUP BY T1.City_Town