SELECT Shop_Name FROM shop WHERE Shop_ID NOT IN (SELECT Shop_ID FROM stock)
What are the names of shops that do not have any 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 )
What are the names of shops that do not have any devices in stock ?