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)
SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track)
<s>[INST] Write mssql query to answer the following question given the database schema. Schema: CREATE TABLE track (name VARCHAR, LOCATION VARCHAR, year_opened VARCHAR, seating INTEGER) Question: Show the name, location, open year for all tracks with a seating higher than the average. [/INST] SELECT name, LOCATION, year_opened FROM track WHERE seating > (SELECT AVG(seating) FROM track) </s>