CREATE TABLE shop (LOCATION VARCHAR(255))
Find the number of shops in each location.
    
SQL: SELECT COUNT(*), LOCATION FROM shop GROUP BY LOCATION