Find the number of shops in each location.
SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION
[{'count(*)': 1, 'Location': 'Espoo'}, {'count(*)': 1, 'Location': 'Helsinki'}, {'count(*)': 1, 'Location': 'Jakobstad'}, {'count(*)': 1, 'Location': 'Kotka'}, {'count(*)': 1, 'Location': 'Kuopio'}, {'count(*)': 1, 'Location': 'Lahti'}, {'count(*)': 1, 'Location': 'Mariehamn'}, {'count(*)': 1, 'Location': 'Turku'}, {'count(*)': 1, 'Location': 'Valkeakoski'}]