2024 Classification Statuses

Medium · Formula 1 · Tables: results, races, status

Count Grand Prix result rows in year '2024' for each recorded status label. Include all statuses, including laps-down classifications; do not label them all retirements. Exclude sprints. Return columns status, results, in that order. Order by results descending, then status 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