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_race_winner
Usage
powerpipe query formula1.query.formula1_race_winner
SQL
select 'Winner' as label, drivers.forename || ' ' || drivers.surname as valuefrom results join drivers on results.driverId = drivers.driverIdwhere results.raceId = $1 and results.position = 1;
Dashboards
The query is used in the dashboards: