[Solved] Query to find man of the tournament [closed]

select player from (select player , sum(runs) from test group by player,runs order by sum(sal) desc) where rownum=1;