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
How many races has the class 'GT'?
assistant
SELECT COUNT( * ) FROM race WHERE class = 'GT';
human
What about without that class?
assistant
SELECT COUNT( * ) FROM race WHERE class != 'GT';
human
What are the track names of them?
assistant
SELECT name FROM track EXCEPT SELECT T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id WHERE T1.class = "GT" ;