I have the following table: John's daily expenses:
ID Date item cost
1 01/01/2021 milk 2
2 01/01/2021 apple 3
3 01/01/2021 cheese 7
4 05/01/2021 milk 4
5 05/01/2021 bread 2
6 05/01/2021 butter 12
7 08/01/2021 milk 2
8 08/01/2021 apple 5
9 08/01/2021 orange 6
how can I make a query to get the whole cost in each day, and also the sum of the expenses up to each day like the following?
Date dailypaid total
01/01/2021 12 12
05/01/2021 18 30
08/01/2021 13 43
thank you