formula1_average_attendance_per_gameformula1_circuit_location_distributionformula1_costructors_countformula1_driver_efficiency_ratingformula1_driver_nationality_distributionformula1_drivers_countformula1_points_per_race_by_teamformula1_race_attendanceformula1_race_average_speedformula1_race_fastest_lapformula1_race_inputformula1_race_overviewformula1_race_scores_over_timeformula1_race_team_points_distributionformula1_race_winnerformula1_races_countformula1_seasons_countformula1_team_standings_by_conferenceformula1_top_scorers_of_seasontop_10_formula1_race_constructor_standingstop_10_formula1_race_driver_standingstop_10_formula1_race_results
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_standingsjoin drivers on driver_standings.driverId = drivers.driverIdjoin laptimes on driver_standings.raceId = laptimes.raceId and driver_standings.driverId = laptimes.driverIdgroup by driver_standings.driverIdorder by "efficiency_rating" desclimit 5;
Dashboards
The query is used in the dashboards: