| The Following 5 Users Say Thank You to Win7Mac For This Useful Post: | ||
| The Following 2 Users Say Thank You to endsormeans For This Useful Post: | ||
| The Following 8 Users Say Thank You to pichlo For This Useful Post: | ||

| The Following 10 Users Say Thank You to juiceme For This Useful Post: | ||
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 | Deutsche Bank | 50.00 | EUR | 50.00 | | 2015-07-03 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-07-03 | PayPal | 25.00 | EUR | 25.00 | | 2015-07-04 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-05 | PayPal | 20.00 | EUR | 20.00 | | 2015-07-06 | PayPal | 150.00 | EUR | 150.00 | | 2015-07-06 | Deutsche Bank | 50.00 | EUR | 50.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 | | 2015-07-27 | PayPal | 48.70 | EUR | 48.70 | | 2015-07-28 | Deutsche Bank | 10.00 | EUR | 10.00 | | 2015-07-30 | Deutsche Bank | 500.00 | EUR | 500.00 | | 2015-08-03 | PayPal | 43.79 | EUR | 43.79 | | 2015-08-03 | Deutsche Bank | 20.00 | EUR | 20.00 | | 2015-08-04 | PayPal | 95.90 | GBP | 133.02 | | 2015-08-04 | PayPal | 100.00 | EUR | 100.00 | | 2015-08-04 | Deutsche Bank | 30.00 | EUR | 30.00 | | 2015-08-04 | Deutsche Bank | 30.00 | EUR | 30.00 | | 2015-08-04 | Deutsche Bank | 25.00 | EUR | 25.00 | | 2015-08-04 | Deutsche Bank | 994.50 | EUR | 994.50 | | 2015-08-04 | Deutsche Bank | 100.00 | EUR | 100.00 | | 2015-08-07 | PayPal | 25.00 | EUR | 25.00 | +------------+---------------+----------+----------+------------+ 46 rows in set (0.00 sec) mysql> mysql> select format(sum(total_amount * exchange_rate), 2) as totals from all_donations; +----------+ | totals | +----------+ | 3,451.43 | +----------+ 1 row in set (0.00 sec) mysql> mysql>
| The Following 10 Users Say Thank You to juiceme For This Useful Post: | ||

| The Following 15 Users Say Thank You to juiceme For This Useful Post: | ||

Donations / € | # | Sum / €
<20: | 10 | 127,40
20: | 11 | 220,00
25-30: | 8 | 216,82
40-50: | 6 | 279,54
100-200: | 9 | 1.113,17
500-1.000: | 2 | 1.494,50
----------------------------------
Total: | 46 | 3.451,43
Avg.: | 1 | 75,03
| The Following 8 Users Say Thank You to Win7Mac For This Useful Post: | ||