Schema: CREATE TABLE performance (LOCATION VARCHAR)
Question: Show different locations and the number of performances at each location.
SQL: SELECT LOCATION, COUNT(*) FROM performance GROUP BY LOCATION