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_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_standingsjoin drivers on driver_standings.driverId = drivers.driverIdgroup by driver_standings.driverIdorder by "average_points_per_game" desclimit 5;
Dashboards
The query is used in the dashboards: