CREATE TABLE shop (shop_id NUMBER, address CLOB, num_of_staff CLOB, score NUMBER, open_year CLOB)
CREATE TABLE happy_hour_member (hh_id NUMBER, member_id NUMBER, total_amount NUMBER)
CREATE TABLE member (member_id NUMBER, name CLOB, membership_card CLOB, age NUMBER, time_of_purchase NUMBER, level_of_membership NUMBER, address CLOB)
CREATE TABLE happy_hour (hh_id NUMBER, shop_id NUMBER, month CLOB, num_of_shaff_in_charge NUMBER)

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")