Database: device
Question: List the names of shops that have no devices in stock.
SQL:
SELECT Shop_Name FROM shop WHERE Shop_ID NOT IN (SELECT Shop_ID FROM stock)