Medium · IPL cricket · Tables: matches, deliveries
For season '2024', total total_runs in innings 1 of each match with recorded deliveries. Group these totals by non-NULL venue, retaining venues with at least three recorded first innings. Return the count as innings and their average as avg_runs, rounded to two decimals. Include incomplete innings as recorded. Return columns venue, innings, avg_runs, in that order. Order by rounded avg_runs descending, then venue 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.