Count Most donator SQL

I wanted to know how would i count most donated number for a person and how to make list from most donator to the lowest.

Database looks like this :

 - Donated Amount - Payer Email
 - 10   [e-mail]
 - 5    [e-mail]
 - 5    [e-mail]
 - 20   [e-mail]
 - 5    [e-mail]
 - 10   [e-mail]

Note : If anyone would guide me on how the table is made on stackoverflow, thank you.

Answer

The easiest is to group by the email, sum the amount to get a total, and order by descending total.

SELECT 
 `Payer Email`, 
 SUM(`Donated Amount`) AS DonatedAmount
-- , COUNT(*) AS TimesDonated
-- , MAX(`Donated Amount`) AS BiggestDonation
FROM YourDonationsTable
GROUP BY `Payer Email`
ORDER BY DonatedAmount DESC

And if you want only the top 3 of those, add a LIMIT 3 at the end of the SQL.