turbot/formula1

Query: formula1_top_scorers_of_season

Usage

powerpipe query formula1.query.formula1_top_scorers_of_season

SQL

select concat(forename, ' ', surname) as "player",
avg(points) as "average_points_per_game"
from
driver_standings
join drivers on driver_standings.driverId = drivers.driverId
group by
driver_standings.driverId
order by
"average_points_per_game" desc
limit 5;

Dashboards

The query is used in the dashboards: