Database: device
Question: What are the names of shops that do not have any devices in stock?
SQL:
SELECT Shop_Name FROM shop WHERE Shop_ID NOT IN (SELECT Shop_ID FROM stock)