find maximum score by each player with each team in cricket world cup 2023

31 Views Asked by At

Find maximum score by each player with each team

select distinct team_innings,batsman_name ,max(runs) 
from batting_summary
group by team_innings,batsman_name
order by max(runs) desc
limit 5;

I want, one player from each team who score maximum

0

There are 0 best solutions below