mysql> mysql> select date, account, format(total_amount, 2) as donation, currency, format(total_amount*exchange_rate, 2) as "sum in EUR" from all_donations order by date; +------------+---------------+----------+----------+------------+ | date | account | donation | currency | sum in EUR | +------------+---------------+----------+----------+------------+ | 2015-07-01 | PayPal | 9.46 | EUR | 9.46 | | 2015-07-01 | PayPal | 10.00 | EUR | 10.00 | | 2015-07-01 | PayPal | 10.00 | EUR | 10.00 | | 2015-07-01 | PayPal | 15.00 | EUR | 15.00 | | 2015-07-01 | Deutsche Bank | 26.82 | EUR | 26.82 | | 2015-07-02 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-02 | PayPal | 47.05 | EUR | 47.05 | | 2015-07-02 | PayPal | 19.27 | EUR | 19.27 | | 2015-07-03 | PayPal | 25.00 | EUR | 25.00 | | 2015-07-03 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-03 | Deutsche Bank | 50.00 | EUR | 50.00 | | 2015-07-04 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-05 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-06 | Deutsche Bank | 50.00 | EUR | 50.00 | | 2015-07-06 | PayPal | 150.00 | EUR | 150.00 | | 2015-07-07 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-07 | PayPal | 25.00 | EUR | 25.00 | | 2015-07-08 | Deutsche Bank | 200.00 | EUR | 200.00 | | 2015-07-08 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-08 | PayPal | 95.90 | GBP | 130.15 | | 2015-07-08 | PayPal | 20.00 | CAD | 13.89 | | 2015-07-10 | PayPal | 40.00 | EUR | 40.00 | | 2015-07-10 | PayPal | 40.49 | PLN | 9.43 | | 2015-07-10 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-10 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-13 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-13 | PayPal | 30.00 | EUR | 30.00 | | 2015-07-15 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-16 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-17 | PayPal | 15.00 | EUR | 15.00 | | 2015-07-17 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-23 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-07-24 | PayPal | 141.65 | NOK | 15.35 | +------------+---------------+----------+----------+------------+ 33 rows in set (0.00 sec) mysql> select format(sum(total_amount * exchange_rate), 2) as totals from all_donations;+----------+ | totals | +----------+ | 1,391.42 | +----------+ 1 row in set (0.00 sec) mysql>