v_monthly_sales is a view with one row per month. For the months of 2025, show
month, revenue and:
change: revenue minus the previous month's revenue (NULL for January)next_revenue: the following month's revenue (NULL for December)End your query with ORDER BY month.
| v_monthly_sales |
|---|
| month |
| revenue |
v_monthly_sales is a view with one row per month. For the months of 2025, show
month, revenue and:
change: revenue minus the previous month's revenue (NULL for January)next_revenue: the following month's revenue (NULL for December)End your query with ORDER BY month.
| v_monthly_sales |
|---|
| month |
| revenue |
| month | revenue | change | next_revenue |
|---|---|---|---|
| 2025-01-01T00:00:00.000Z | 160247.90 | NULL | 146676.55 |
| 2025-02-01T00:00:00.000Z | 146676.55 | -13571.35 | 100916.70 |
| 2025-03-01T00:00:00.000Z | 100916.70 | -45759.85 | 72001.05 |
| 2025-04-01T00:00:00.000Z | 72001.05 | -28915.65 | 145151.80 |
| 2025-05-01T00:00:00.000Z | 145151.80 | 73150.75 | 136436.15 |
| 2025-06-01T00:00:00.000Z | 136436.15 | -8715.65 | 134804.70 |
| 2025-07-01T00:00:00.000Z | 134804.70 | -1631.45 | 26616.35 |
| 2025-08-01T00:00:00.000Z | 26616.35 | -108188.35 | 251053.35 |
| 2025-09-01T00:00:00.000Z | 251053.35 | 224437.00 | 63006.65 |
| 2025-10-01T00:00:00.000Z | 63006.65 | -188046.70 | 8999.00 |
| 2025-11-01T00:00:00.000Z | 8999.00 | -54007.65 | 5297.00 |
| 2025-12-01T00:00:00.000Z | 5297.00 | -3702.00 | NULL |
Run query to see output