CREATE TABLE shop (name VARCHAR(255), shop_id VARCHAR(255)); CREATE TABLE hiring (shop_id VARCHAR(255))
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