Write a Monthly Revenue Report

You have an `Orders` table with `CustomerId`, `TotalAmount`, `Status`, `CreatedAt`. Write a single SQL query that produces: month, revenue that month, cumulative revenue to date, and month-over-month percentage change. No application-side calculation allowed.

Your progress0%

Requirements

Skills you'll use

SQLCTEsWindow FunctionsAggregations

Read this first

This task is based on the lesson below. Complete the reading before attempting it.

Go to lesson

What to expect

Difficulty: intermediate
Time: 30 min
Steps: 6
Type: Build