SELECT count(*) ,  t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id  =  t2.shop_id GROUP BY t2.name
For each shop, return the number of employees working there and the name of the shop.
SELECT count ( * ) , t2.name FROM hiring AS t1 JOIN shop AS t2 ON t1.shop_id = t2.shop_id GROUP BY t2.name
select count ( * ) , t2 . name from hiring as t1 join shop as t2 on t1 . shop_id = t2 . shop_id group by t2 . name
For each shop , return the number of employees working there and the name of the shop .