Show the name, location, open year for all tracks with a seating higher than the average.
CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, year_opened VARCHAR, seating INTEGER)
[SQL] SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track) [/SQL]