86

Top Performing Batsmen per Team

Hardwindow functionRANKPARTITION BY

Problem Description

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 | | ... | ... | ... |

Hints

Unlocks after 2 more attempts
Submit your solution to unlock hints
//#86 Top Performing Batsmen per Team
Hard

Loading schema...

Loading editor...

No results yet

Run a query to see results