View Single Post
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#105
Here's the donation state as of today:
Code:
mysql> 
mysql> select date, account, total_amount, currency from all_donations order by date;
+------------+---------------+--------------+----------+
| date       | account       | total_amount | currency |
+------------+---------------+--------------+----------+
| 2015-07-01 | PayPal        |         9.46 | EUR      |
| 2015-07-01 | PayPal        |           10 | EUR      |
| 2015-07-01 | PayPal        |           10 | EUR      |
| 2015-07-01 | PayPal        |           15 | EUR      |
| 2015-07-01 | Deutsche Bank |        26.82 | EUR      |
| 2015-07-02 | Deutsche Bank |          100 | EUR      |
| 2015-07-02 | PayPal        |        47.05 | EUR      |
| 2015-07-02 | PayPal        |        19.27 | EUR      |
| 2015-07-03 | PayPal        |           25 | EUR      |
| 2015-07-03 | Deutsche Bank |          100 | EUR      |
| 2015-07-03 | Deutsche Bank |           50 | EUR      |
| 2015-07-04 | PayPal        |           20 | EUR      |
| 2015-07-05 | PayPal        |           20 | EUR      |
| 2015-07-06 | PayPal        |          150 | EUR      |
| 2015-07-06 | Deutsche Bank |           50 | EUR      |
| 2015-07-07 | PayPal        |           25 | EUR      |
| 2015-07-07 | PayPal        |           20 | EUR      |
| 2015-07-08 | PayPal        |           20 | CAD      |
| 2015-07-08 | PayPal        |         95.9 | GBP      |
| 2015-07-08 | Deutsche Bank |           20 | EUR      |
| 2015-07-08 | Deutsche Bank |          200 | EUR      |
| 2015-07-10 | Deutsche Bank |           20 | EUR      |
| 2015-07-10 | Deutsche Bank |           20 | EUR      |
| 2015-07-10 | PayPal        |        40.49 | PLN      |
| 2015-07-10 | PayPal        |           40 | EUR      |
| 2015-07-13 | PayPal        |           30 | EUR      |
| 2015-07-13 | Deutsche Bank |           20 | EUR      |
| 2015-07-15 | Deutsche Bank |          100 | EUR      |
| 2015-07-16 | Deutsche Bank |           20 | EUR      |
+------------+---------------+--------------+----------+
29 rows in set (0.00 sec)

mysql> select sum(total_amount * exchange_rate) as calculated from all_donations;
+--------------------+
| calculated         |
+--------------------+
| 1321.0700000021802 |
+--------------------+
1 row in set (0.00 sec)

mysql>
 

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