View Single Post
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#148
Here's the donation state as of today:
Code:
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: