text: CREATE TABLE race (name VARCHAR, CLASS VARCHAR, date VARCHAR) -- Show name, class, and date for all races. SELECT name, CLASS, date FROM race CREATE TABLE race (CLASS VARCHAR) -- Show the race class and number of races in each class. SELECT CLASS, COUNT(*) FROM race GROUP BY CLASS CREATE TABLE race (CLASS VARCHAR) -- What is the race class with most number of races. SELECT CLASS FROM race GROUP BY CLASS ORDER BY COUNT(*) DESC LIMIT 1 CREATE TABLE race (CLASS VARCHAR) -- List the race class with at least two races. SELECT CLASS FROM race GROUP BY CLASS HAVING COUNT(*) >= 2 CREATE TABLE race (track_id VARCHAR, class VARCHAR); CREATE TABLE track (name VARCHAR); CREATE TABLE track (name VARCHAR, track_id VARCHAR) -- What are the names for tracks without a race in class 'GT'. SELECT name FROM track EXCEPT SELECT T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id WHERE T1.class = 'GT' CREATE TABLE track (name VARCHAR, track_id VARCHAR); CREATE TABLE race (name VARCHAR, track_id VARCHAR) -- Show all track names that have had no races. SELECT name FROM track WHERE NOT track_id IN (SELECT track_id FROM race) CREATE TABLE track (year_opened VARCHAR, seating INTEGER) -- Show year where a track with a seating at least 5000 opened and a track with seating no more than 4000 opened. SELECT year_opened FROM track WHERE seating BETWEEN 4000 AND 5000 CREATE TABLE track (name VARCHAR, track_id VARCHAR); CREATE TABLE race (track_id VARCHAR) -- Show the name of track and the number of races in each track. SELECT T2.name, COUNT(*) FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id GROUP BY T1.track_id