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

Show the name and date for each race and its track name.
SELECT T1.name, T1.date, T2.name FROM race AS T1 JOIN track AS T2 ON T1.track_id = T2.track_id
SELECT "T1"."name", "T1"."date", "T2"."name" FROM "race" "T1" JOIN "track" "T2" ON "T1"."track_id" = "T2"."track_id"