What are the names of the tracks for each race?
select t2.name, t1.name from race as t1 join track as t2 on t1.track_id = t2.track_id
For each track name, how many races for each?
select t2.name, count(*) from race as t1 join track as t2 on t1.track_id = t2.track_id group by t1.track_id
How many tracks have at least two races?
select count(*) from race as t1 join track as t2 on t1.track_id = t2.track_id group by t1.track_id having count(*) >= 2
What about only one race? Show the track name and location?
select t2.name, t2.location from race as t1 join track as t2 on t1.track_id = t2.track_id group by t1.track_id having count(*) = 1