Database: employee_hire_evaluation
Question: Find the number of shops in each location.
SQL:
SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION