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


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