Query: formula1_average_attendance_per_game

select
  date as "game",
  avg(total_results) as "average_attendance"
from
  (
    select
      r.date,
      count(*) as total_results
    from
      races r
      join results rs on r.raceId = rs.raceId
    group by
      r.date
  ) as attendance_counts
group by
  date;