Query: formula1_race_team_points_distribution

select
  constructors.name as "Constructor",
  sum(results.points) as "Total Points"
from
  results
  join constructors on results.constructorId = constructors.constructorId
where
  results.raceId = $1
group by
  constructors.name
order by
  "Total Points" desc;