CREATE TABLE track (track_id NUMBER, name CLOB, location CLOB, seating NUMBER, year_opened NUMBER)
CREATE TABLE race (race_id NUMBER, name CLOB, class CLOB, date CLOB, track_id CLOB)

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)
SELECT "name", "location", "year_opened" FROM "track" WHERE "seating" > (SELECT AVG("seating") FROM "track")