Hard · Formula 1 · Tables: results, races, drivers, constructors
Total each driver's 2024 Grand Prix results.points separately within each constructor. For every constructor, return all drivers tied for that constructor's highest total. A driver who changes teams has separate totals. Exclude sprints. Return integer IDs, full driver name and numeric gp_points. Return columns constructor_id, constructor, driver_id, driver, gp_points, in that order. Order by constructor_id 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.