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_constructor_standings
Usage
powerpipe query formula1.query.top_10_formula1_race_constructor_standings
SQL
select constructors.name as "Constructor", constructor_standings.points as "Points", constructor_standings.position as "Position", constructor_standings.wins as "Wins"from constructor_standings join constructors on constructor_standings.constructorId = constructors.constructorIdwhere constructor_standings.raceId = $1order by constructor_standings.positionlimit 10;
Dashboards
The query is used in the dashboards: