I need to get a set of total transactions over time on a weekly interval. Essentially I need a total-transactions-to-date column. When I group by WEEK(Date) I get the amount of transactions for that week, but need to also get the transactions from any time before that week as well.
So let's say I have a table like this:
TransactionID | Date
---------------|-----------
1 | 8-04-2014
2 | 8-05-2014
3 | 8-18-2014
4 | 8-18-2014
5 | 8-20-2014
I want to have a select statement that would provide me with something like
TotalTransactionsToDate | Week | Year
------------------------|------|------
2 | 1 | 2014
5 | 3 | 2014
I am using MySql 5.5.38