Question

Consider the table containing the transactions of a restaurant The table structure is like: transaction_id | date | amount 1 | 2019-07-01 | 100 2 | 2019-07-01 | 120 3 | 2019-07-01 | 110 4 | 2019-07-02 | 160 5 | 2019-07-02 | 700 …... Question: Write a SQL query to find the increase in total transaction amount on a daily basis. To clarify further, find the change (increase or decrease) in total transaction amount from the previous day Expected output: date | changed_by 2019-07-01 | 330 2019-07-02 | 530 2019-07-03 | -470
​

Answer 1

Answer:

transaction_id | date | amount 1 | 2019-07-01 | 100 2 | 2019-07-01 | 120 3 | 2019-07-01 | 110 4 | 2019-07-02 | 160 5 | 2019-07-02 | 700 …...