SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring)
Which shops run with no employees? Find the shop names
SELECT name FROM shop WHERE shop_id NOT IN ( SELECT shop_id FROM hiring )
select name from shop where shop_id not in ( select shop_id from hiring )
Which shops run with no employees ? Find the shop names