turbot/formula1

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.constructorId
where
constructor_standings.raceId = $1
order by
constructor_standings.position
limit 10;

Dashboards

The query is used in the dashboards: