turbot/formula1

Query: formula1_driver_efficiency_rating

Usage

powerpipe query formula1.query.formula1_driver_efficiency_rating

SQL

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

Dashboards

The query is used in the dashboards: