Medium · IPL cricket · Tables: matches, deliveries
Count delivery rows with numeric is_wicket = 1 in season '2024', grouped by their recorded dismissal_kind. Include all innings and all dismissal types; this is not a bowler-credit calculation. Return columns dismissal_kind, wickets, in that order. Order by wickets descending, then dismissal_kind ascending (SQLite NULL first for ties). All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text.