SELECT name FROM shop WHERE shop_id NOT IN (SELECT shop_id FROM hiring)
Find the name of the shops that do not hire any employee.
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 )
Find the name of the shops that do not hire any employee .