turbot/formula1

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

Dashboards

The query is used in the dashboards: