advancedDate Functions 15m est

Month-over-Month Sales Growth

Problem Statement

Calculate the month-over-month percentage growth in sales revenue. Return the year-month string (formatted as 'YYYY-MM'), the monthly revenue (aliased as `monthly_revenue`), the previous month's revenue (aliased as `prev_month_revenue`), and the percentage growth (aliased as `growth_percentage`, rounded to 2 decimal places).

Skills Evaluated

LAGstrftimeWindow FunctionsROUND
Write your SQL query in the editor on the right and click **Run Query**. The system runs your query and compares the result dataset with the official solution. Results must match row-for-row, column-for-column.

Expected Output Format

Executing expected result set...
SQL Query WorkspaceSQLite v3.45 (WASM Mode)
QUICK INSERT:
1