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
List all the information about the tracks.
assistant
SELECT * FROM track;
human
Which names and seatings of the tracks that are opened later than the year 1950 ?
assistant
SELECT name , seating FROM track WHERE year_opened > 1950;
human
What about after the year 2000?
assistant
SELECT name , seating FROM track WHERE year_opened > 2000 ;