CREATE TABLE stock (shop_id NUMBER, device_id NUMBER, quantity NUMBER)
CREATE TABLE device (device_id NUMBER, device CLOB, carrier CLOB, package_version CLOB, applications CLOB, software_platform CLOB)
CREATE TABLE shop (shop_id NUMBER, shop_name CLOB, location CLOB, open_date CLOB, open_year NUMBER)

What are the names of shops that do not have any 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")