Database: cre_Drama_Workshop_Groups
Question: How many drama workshop groups are there in each city? Return both the city and the count.
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