SCHEMA:
CREATE TABLE shop (LOCATION VARCHAR)
USER:
Find the number of shops in each location.

QUERY:
SELECT COUNT(*), LOCATION FROM shop GROUP BY LOCATION