Schema: CREATE TABLE cinema (LOCATION VARCHAR)
Question: Show each location and the number of cinemas there.
SQL: SELECT LOCATION, COUNT(*) FROM cinema GROUP BY LOCATION