CREATE TABLE shop (shop_id NUMBER, address CLOB, num_of_staff CLOB, score NUMBER, open_year CLOB)
CREATE TABLE happy_hour (hh_id NUMBER, shop_id NUMBER, month CLOB, num_of_shaff_in_charge NUMBER)
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)

How many members are not living in Hartford?
SELECT COUNT(*) FROM member WHERE address <> 'Hartford'
SELECT COUNT(*) FROM "member" WHERE "address" <> 'Hartford'