Show each location and the number of cinemas there.
CREATE TABLE cinema (LOCATION VARCHAR)
SELECT LOCATION, COUNT(*) FROM cinema GROUP BY LOCATION
### Context: CREATE TABLE cinema (LOCATION VARCHAR) ### Question: Show each location and the number of cinemas there. ### Answer: SELECT LOCATION, COUNT(*) FROM cinema GROUP BY LOCATION