turbot/formula1

Query: formula1_points_per_race_by_team

Usage

powerpipe query formula1.query.formula1_points_per_race_by_team

SQL

select constructors.name as "team",
avg(constructor_standings.points) as "average_points"
from
constructor_standings
join constructors on constructor_standings.constructorId = constructors.constructorId
group by
constructor_standings.constructorId
order by
"average_points" desc;

Dashboards

The query is used in the dashboards: