{"queries":[{"id":"seasons","compiledQueryString":"select distinct year from f1.teammate_battles order by year desc","inputQueryString":"select distinct year from f1.teammate_battles order by year desc","compiled":false,"inline":true},{"id":"battles","compiledQueryString":"-- Orient every pairing so the faster qualifier is listed first\nselect\n team_name,\n team_colour,\n case when median_quali_gap_s <= 0 then driver_a else driver_b end as faster_driver,\n case when median_quali_gap_s <= 0 then driver_b else driver_a end as slower_driver,\n abs(median_quali_gap_s) as quali_gap_s,\n case when median_quali_gap_s <= 0 then quali_ahead_a || ' – ' || quali_ahead_b\n else quali_ahead_b || ' – ' || quali_ahead_a end as quali_h2h,\n case when median_quali_gap_s <= 0 then race_ahead_a || ' – ' || race_ahead_b\n else race_ahead_b || ' – ' || race_ahead_a end as race_h2h,\n case when median_quali_gap_s <= 0 then points_a || ' – ' || points_b\n else points_b || ' – ' || points_a end as points_split,\n case when median_quali_gap_s <= 0 then driver_a || ' vs ' || driver_b\n else driver_b || ' vs ' || driver_a end as pairing,\n qualifying_sessions\nfrom f1.teammate_battles\nwhere year = ${inputs.season.value}\n and qualifying_sessions >= 5\n and median_quali_gap_s is not null\norder by quali_gap_s desc","inputQueryString":"-- Orient every pairing so the faster qualifier is listed first\nselect\n team_name,\n team_colour,\n case when median_quali_gap_s <= 0 then driver_a else driver_b end as faster_driver,\n case when median_quali_gap_s <= 0 then driver_b else driver_a end as slower_driver,\n abs(median_quali_gap_s) as quali_gap_s,\n case when median_quali_gap_s <= 0 then quali_ahead_a || ' – ' || quali_ahead_b\n else quali_ahead_b || ' – ' || quali_ahead_a end as quali_h2h,\n case when median_quali_gap_s <= 0 then race_ahead_a || ' – ' || race_ahead_b\n else race_ahead_b || ' – ' || race_ahead_a end as race_h2h,\n case when median_quali_gap_s <= 0 then points_a || ' – ' || points_b\n else points_b || ' – ' || points_a end as points_split,\n case when median_quali_gap_s <= 0 then driver_a || ' vs ' || driver_b\n else driver_b || ' vs ' || driver_a end as pairing,\n qualifying_sessions\nfrom f1.teammate_battles\nwhere year = ${inputs.season.value}\n and qualifying_sessions >= 5\n and median_quali_gap_s is not null\norder by quali_gap_s desc","compiled":false,"inline":true}]}

Teammate Battles

Qualifying Margin

Head to Head