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