Hard
Window Functions
Pro Challenge

Month-over-Month Order Growth

Summarize monthly order volume and revenue, then compare each month with the previous month using LAG(). Return columns: month, orders, revenue, prev_revenue, revenue_change. Order results by: month.

Preparing the interactive SQL workspace...

Challenge overview

What you will practice

Summarize monthly order volume and revenue, then compare each month with the previous month using LAG(). Return columns: month, orders, revenue, prev_revenue, revenue_change. Order results by: month.

Difficulty
Advanced
SQL concept
Window Functions