Hello community, Here's a tricky one and I need some help please. I have a current table of transactions. My requirement is to maintain a history of transactions for every user. I need to leave out the latest from current transactions and backup all previous. In the history table I would also like to maintain a count of the number of transactions that occurred on that day, total transactions as of that day for a user and previous transaction date for each record in history table.   An example is below. Any help is much appreciated.          current           id dt val       1 3/5/19 Test       1 3/10/19 Test       1 3/10/19 Test       1 3/15/19 Test       2 1/14/19 Test       3 1/14/19 Test       3 1/12/19 Test                               history           id dt val prev_Dt volume tot_as_of_today 1 3/10/19 Test 3/5/19 2 3 1 3/5/19 Test null 1 1 3 1/12/19 Test null 1 1 ... View more