CREATE TABLE track (name VARCHAR2, track_id VARCHAR2)
CREATE TABLE race (track_id VARCHAR2)

Show the name of track and the number of races in each track.
SELECT T2.name, COUNT(*) FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id GROUP BY T1.track_id
SELECT "T2"."name", COUNT(*) FROM "race" "T1" JOIN "track" "T2" ON "T1"."track_id" = "T2"."track_id" GROUP BY "T1"."track_id"