Database: employee_hire_evaluation
Question: How many shops are there in each location?
SQL:
SELECT count(*) ,  LOCATION FROM shop GROUP BY LOCATION