CREATE TABLE track (track_id NUMBER, name CLOB, location CLOB, seating NUMBER, year_opened NUMBER)
CREATE TABLE race (race_id NUMBER, name CLOB, class CLOB, date CLOB, track_id CLOB)

Show the race class and number of races in each class.
SELECT class, COUNT(*) FROM race GROUP BY class
SELECT "class", COUNT(*) FROM "race" GROUP BY "class"