| date | follwer |
|---|---|
| 23-10-2022 | 1 |
| 22-10-2022 | 0 |
| 21-10-2022 | 1 |
| 20-10-2022 | 2 |
Total followers 250
Expected output:
| date | follwer |
|---|---|
| 23-10-2022 | 251 |
| 22-10-2022 | 250 |
| 21-10-2022 | 249 |
| 20-10-2022 | 247 |
I want to implement above result using sql can one one suggest me some solution
>Solution :
Your output could be generated by this query:
SELECT date, 251 - SUM(follwer) OVER (ORDER BY date DESC) + follwer AS follwer
FROM yourTabld
ORDER BY date DESC;