Database: employee_hire_evaluation
Question: Find the number of employees hired in each shop; show the shop name as well.
SQL:
SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name