Task: Text to Code
Input (English): Find the number of employees hired in each shop; show the shop name as well.
Output (English): SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name