turbot/formula1

Query: formula1_race_winner

Usage

powerpipe query formula1.query.formula1_race_winner

SQL

select
'Winner' as label,
drivers.forename || ' ' || drivers.surname as value
from
results
join drivers on results.driverId = drivers.driverId
where
results.raceId = $1
and results.position = 1;

Dashboards

The query is used in the dashboards: