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
How many races for the track name 'Auto Club Speedway'?
select t2.name,t1.name, count(*) from race as t1 join track as t2 on t1.track_id = t2.track_id group by t1.track_id having t2.name = 'Auto club Speedway'
For each track name, how many races are there?
select t2.name, count(*) from race as t1 join track as t2 on t1.track_id = t2.track_id group by t1.track_id