text: CREATE TABLE track (Id VARCHAR) -- How many tracks do we have? SELECT COUNT(*) FROM track CREATE TABLE track (name VARCHAR, LOCATION VARCHAR) -- Show the name and location for all tracks. SELECT name, LOCATION FROM track CREATE TABLE track (name VARCHAR, seating VARCHAR, year_opened INTEGER) -- Show names and seatings, ordered by seating for all tracks opened after 2000. SELECT name, seating FROM track WHERE year_opened > 2000 ORDER BY seating CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, seating VARCHAR, year_opened VARCHAR) -- What is the name, location and seating for the most recently opened track? SELECT name, LOCATION, seating FROM track ORDER BY year_opened DESC LIMIT 1 CREATE TABLE track (seating INTEGER) -- What is the minimum, maximum, and average seating for all tracks. SELECT MIN(seating), MAX(seating), AVG(seating) FROM track CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, year_opened VARCHAR, seating INTEGER) -- Show the name, location, open year for all tracks with a seating higher than the average. SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track) CREATE TABLE track (LOCATION VARCHAR) -- What are distinct locations where tracks are located? SELECT DISTINCT LOCATION FROM track CREATE TABLE race (Id VARCHAR) -- How many races are there? SELECT COUNT(*) FROM race CREATE TABLE race (CLASS VARCHAR) -- What are the distinct classes that races can have? SELECT DISTINCT CLASS FROM race