Database: cinema
Question: Show each location and the number of cinemas there.
SQL:
SELECT LOCATION ,  count(*) FROM cinema GROUP BY LOCATION