Hard · Formula 1 · Tables: races, results, drivers
Find the ten 2024 Grand Prix result rows with the largest positive gain from starting grid to finishing position. Keep only grid greater than 0 and numeric final position between 1 and 10. positions_gained equals numeric grid minus numeric position. Return integer race_id, race name as race, integer driver_id, full driver name as driver, integer grid, integer finish and integer positions_gained. Order by positions_gained descending, numeric race_id ascending, then numeric driver_id ascending; return ten rows. Grid 0 and unclassified results are excluded; sprints do not count.