mysql> mysql> select date, account, total_amount from all_donations order by date; +------------+--------------+--------------+ | date | account | total_amount | +------------+--------------+--------------+ | 2015-07-01 | PayPal | 9.46 | | 2015-07-01 | PayPal | 10 | | 2015-07-01 | PayPal | 10 | | 2015-07-01 | PayPal | 15 | | 2015-07-01 | Deutsche Bank | 26.82 | | 2015-07-02 | PayPal | 19.27 | | 2015-07-02 | PayPal | 47.05 | | 2015-07-02 | Deutsche Bank | 100 | +------------+--------------+--------------+ 8 rows in set (0.00 sec) mysql> select sum(total_amount) from all_donations; +-------------------+ | sum(total_amount) | +-------------------+ | 237.6 | +-------------------+ 1 row in set (0.00 sec)