View Single Post
Community Council | Posts: 4,920 | Thanked: 12,867 times | Joined on May 2012 @ Southerrn Finland
#57
Here's the donation state as of today:

Code:
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)

Last edited by HtheB; 2015-07-03 at 19:09.
 

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