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
[{'Location': 'County Clare', 'count(*)': 3}, {'Location': 'County Cork', 'count(*)': 1}, {'Location': 'County Dublin', 'count(*)': 1}, {'Location': 'County Laois', 'count(*)': 1}, {'Location': 'County Louth', 'count(*)': 1}, {'Location': 'County Tipperary', 'count(*)': 2}, {'Location': 'County Wicklow', 'count(*)': 1}]