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
What are the names of those tracks?
assistant
SELECT name FROM track WHERE track_id NOT IN ( SELECT track_id FROM race );
human
Can you show me the location and year opened for these tracks?
assistant
SELECT Location , Year_Opened FROM track WHERE track_id NOT IN ( SELECT track_id FROM race ) ;