CREATE TABLE shop (address VARCHAR2, num_of_staff VARCHAR2, shop_id VARCHAR2)
CREATE TABLE happy_hour (address VARCHAR2, num_of_staff VARCHAR2, shop_id VARCHAR2)

Find the address and staff number of the shops that do not have any happy hour.
SELECT address, num_of_staff FROM shop WHERE NOT shop_id IN (SELECT shop_id FROM happy_hour)
SELECT "address", "num_of_staff" FROM "shop" WHERE NOT "shop_id" IN (SELECT "shop_id" FROM "happy_hour")