I have the following tables with me :
Table 1 Title : Runs
+------------+---------+
| P_ID | Runs |
+------------+---------+
| 1 | 100 |
| 2 | 45 |
| 3 | 35 |
| 1 | 90 |
| 2 | 85 |
+------------+---------+
Table 2 Title : Player
+------------+---------+
| P_ID | Name |
+------------+---------+
| 1 | Dhoni |
| 2 | Sehawag |
| 3 | Sachin |
| 4 | Dravid |
| 5 | Kohli |
+------------+---------+
I have to find the player name whose sum of runs is maximum.
I am new to MySQL and not able to figure out the correct/most efficient query for that, please help.