SELECT LOCATION ,  count(*) FROM cinema GROUP BY LOCATION
Show each location and the number of cinemas there.
SELECT LOCATION , count ( * ) FROM cinema GROUP BY LOCATION
select location , count ( * ) from cinema group by location
Show each location and the number of cinemas there .