text: CREATE TABLE member (name VARCHAR, address VARCHAR) -- Give me the names of members whose address is in Harford or Waterbury. SELECT name FROM member WHERE address = 'Harford' OR address = 'Waterbury' CREATE TABLE member (name VARCHAR, member_id VARCHAR, Membership_card VARCHAR, age VARCHAR) -- Find the ids and names of members who are under age 30 or with black membership card. SELECT name, member_id FROM member WHERE Membership_card = 'Black' OR age < 30 CREATE TABLE member (Time_of_purchase VARCHAR, age VARCHAR, address VARCHAR) -- Find the purchase time, age and address of each member, and show the results in the order of purchase time. SELECT Time_of_purchase, age, address FROM member ORDER BY Time_of_purchase CREATE TABLE member (Membership_card VARCHAR) -- Which membership card has more than 5 members? SELECT Membership_card FROM member GROUP BY Membership_card HAVING COUNT(*) > 5 CREATE TABLE member (address VARCHAR, age INTEGER) -- Which address has both members younger than 30 and members older than 40? SELECT address FROM member WHERE age < 30 INTERSECT SELECT address FROM member WHERE age > 40 CREATE TABLE member (membership_card VARCHAR, address VARCHAR) -- What is the membership card held by both members living in Hartford and ones living in Waterbury address? SELECT membership_card FROM member WHERE address = 'Hartford' INTERSECT SELECT membership_card FROM member WHERE address = 'Waterbury'