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 tracks were opened after year 2000? | Here are the ids for tracks that were opened after year 2000, including 2 and 6. | What are their names?
assistant
SELECT name FROM track WHERE year_opened > 2000;
human
And what are their seating capacity?
assistant
SELECT name , seating FROM track WHERE year_opened > 2000;
human
Yes, what are their locations?
assistant
SELECT name , location FROM track WHERE year_opened > 2000 ;