text: CREATE TABLE track (name VARCHAR, track_id VARCHAR); CREATE TABLE race (track_id VARCHAR) -- Show the name of track with most number of races. SELECT T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id GROUP BY T1.track_id ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE race (name VARCHAR, date VARCHAR, track_id VARCHAR); CREATE TABLE track (name VARCHAR, track_id VARCHAR) -- Show the name and date for each race and its track name. SELECT T1.name, T1.date, T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id CREATE TABLE race (track_id VARCHAR); CREATE TABLE track (name VARCHAR, location VARCHAR, track_id VARCHAR) -- Show the name and location of track with 1 race. SELECT T2.name, T2.location FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id GROUP BY T1.track_id HAVING COUNT(*) = 1 CREATE TABLE track (LOCATION VARCHAR, seating INTEGER) -- Find the locations where have both tracks with more than 90000 seats and tracks with less than 70000 seats. SELECT LOCATION FROM track WHERE seating > 90000 INTERSECT SELECT LOCATION FROM track WHERE seating < 70000 CREATE TABLE member (Membership_card VARCHAR) -- How many members have the black membership card? SELECT COUNT(*) FROM member WHERE Membership_card = 'Black' CREATE TABLE member (address VARCHAR) -- Find the number of members living in each address. SELECT COUNT(*), address FROM member GROUP BY address