Database: employee_hire_evaluation
Question: For each shop, return the number of employees working there and the name of the shop.
SQL:
SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name