SELECT Shop_Name FROM shop WHERE Shop_ID NOT IN (SELECT Shop_ID FROM stock)
List the names of shops that have no devices in stock.
SELECT Shop_Name FROM shop WHERE Shop_ID NOT IN ( SELECT Shop_ID FROM stock )
select shop_name from shop where shop_id not in ( select shop_id from stock )
List the names of shops that have no devices in stock .