solulubeta
Sign in
SQL / Window functions & CTEs
06.10 · SQL

Month over month

Return sale_month (text like 2024-01), revenue (that month's total) and prev_revenue (the previous month's revenue; NULL for the first month), sorted by sale_month.

Hard 3 min Pro

This lesson is part of solulu Pro

Return sale_month (text like 2024-01), revenue (that month's total) and prev_revenue (the previous month's revenue; NULL for the first month), sorted by sale_month.

Lifetime ₹2,000 ₹1,000 · Beta offer
Mark this as done when you are finished.

Item 65 of 77 · updated 2026-10-12