2024 Race-Winner Running Points

Hard · Formula 1 · Tables: races, results, drivers

For each 2024 Grand Prix winner, show that driver's cumulative results.points through that race, counting their earlier 2024 Grand Prix result rows as well. Do not count sprint points or standings snapshots. Return integer round, integer driver_id, full name, and numeric gp_points_so_far. Return columns round, driver_id, driver, gp_points_so_far, in that order. Order by round ascending, then driver_id ascending. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text.

More SQL practice problems