Table 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