CREATE TABLE Addresses (City_Town VARCHAR2, Address_ID VARCHAR2)
CREATE TABLE Drama_Workshop_Groups (Address_ID VARCHAR2)

Show all cities along with the number of drama workshop groups in each city.
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
SELECT "T1"."City_Town", COUNT(*) FROM "Addresses" "T1" JOIN "Drama_Workshop_Groups" "T2" ON "T1"."Address_ID" = "T2"."Address_ID" GROUP BY "T1"."City_Town"