CREATE TABLE stock (Shop_Name VARCHAR, Shop_ID VARCHAR)
CREATE TABLE shop (Shop_Name VARCHAR, Shop_ID VARCHAR)

List the names of shops that have no devices in stock.
SELECT Shop_Name FROM shop WHERE NOT Shop_ID IN (SELECT Shop_ID FROM stock)
SELECT "Shop_Name" FROM "shop" WHERE NOT "Shop_ID" IN (SELECT "Shop_ID" FROM "stock")