human
Schema:
race (Race_ID, Name, Class, Date, Track_ID)
track (Track_ID, Name, Location, Seating, Year_Opened)
Please answer with SQL.
assistant
Sure, I understand.
human
Which was the most recently opened track?
assistant
SELECT name FROM track ORDER BY year_opened DESC LIMIT 1;
human
What is the seating capacity for Chicagoland Speedway?
assistant
SELECT Seating FROM track WHERE Name = 'Chicagoland Speedway';
human
What is the location of the Chicagoland Speedway tract?
assistant
SELECT Location FROM track WHERE Name = "Chicagoland Speedway" ;