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: top_10_formula1_race_results
Usage
powerpipe query formula1.query.top_10_formula1_race_results
SQL
select results.position as "Position", drivers.forename || ' ' || drivers.surname as "Driver", constructors.name as "Constructor", results.points as "Points", results.laps as "Laps", results.time as "Time", results.statusId as "Status"from results join drivers on results.driverId = drivers.driverId join constructors on results.constructorId = constructors.constructorIdwhere results.raceId = $1order by results.positionlimit 10;
Dashboards
The query is used in the dashboards: