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
give me the race class with the most number of races
assistant
SELECT CLASS FROM race GROUP BY CLASS ORDER BY COUNT( * ) DESC LIMIT 1;
human
on what date is it?
assistant
SELECT Date FROM race WHERE Class = ( SELECT Class FROM race GROUP BY CLASS ORDER BY COUNT( * ) DESC LIMIT 1 ) ;