Hard · IPL cricket · Tables: matches, deliveries
Total each batter's batsman_runs for each batting_team in season '2024', using regular innings 1 and 2. Choose exactly the first three batters per team after sorting runs descending and batter ascending. team_rank is the 1-based row number within the team, not a shared rank. Return columns batting_team, batter, runs, team_rank, in that order. Order by batting_team ascending, then team_rank 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.