Top Performing Batsmen per Team

Write a SQL query to find the top scorer from each IPL team.

Expected Columns

• team_name
• player_name
• total_runs

Example Output

| team_name | player_name | total_runs | |-----------|-------------|------------| | Chennai Super Kings | MS Dhoni | 45 | | Delhi Capitals | David Warner | 95 | | ... | ... | ... |