text: CREATE TABLE member (address VARCHAR) -- How many members are not living in Hartford? SELECT COUNT(*) FROM member WHERE address <> 'Hartford' CREATE TABLE member (address VARCHAR, Membership_card VARCHAR) -- Which address do not have any member with the black membership card? SELECT address FROM member EXCEPT SELECT address FROM member WHERE Membership_card = 'Black' CREATE TABLE shop (address VARCHAR, open_year VARCHAR) -- Show the shop addresses ordered by their opening year. SELECT address FROM shop ORDER BY open_year CREATE TABLE shop (num_of_staff INTEGER, score INTEGER) -- What are the average score and average staff number of all shops? SELECT AVG(num_of_staff), AVG(score) FROM shop CREATE TABLE shop (shop_id VARCHAR, address VARCHAR, score INTEGER) -- Find the id and address of the shops whose score is below the average score. SELECT shop_id, address FROM shop WHERE score < (SELECT AVG(score) FROM shop) CREATE TABLE shop (address VARCHAR, num_of_staff VARCHAR, shop_id VARCHAR); CREATE TABLE happy_hour (address VARCHAR, num_of_staff VARCHAR, shop_id VARCHAR) -- 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) CREATE TABLE shop (address VARCHAR, shop_id VARCHAR); CREATE TABLE happy_hour (shop_id VARCHAR) -- What are the id and address of the shops which have a happy hour in May? SELECT t1.address, t1.shop_id FROM shop AS t1 JOIN happy_hour AS t2 ON t1.shop_id = t2.shop_id WHERE MONTH = 'May'