Medium · IPL cricket · Tables: deliveries
First total batsman_runs for each match_id, inning and batter in regular innings 1 and 2. Count innings of at least 50 runs for each batter, including centuries. Return the ten batters with the most qualifying innings. Return columns batter, fifty_plus_innings, in that order. Order by fifty_plus_innings descending, then batter ascending; return ten rows. All source columns have TEXT affinity: cast numeric inputs before numeric comparisons or calculations. Counts and calculated numeric outputs must be numbers, not text.