Scenario SQL Question
Identify Week-on-Week (WoW) Sales Growth
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
For 2024, compute weekly revenue and the percentage growth versus the previous week using LAG. Return year, week_num, weekly_revenue, prev_week_revenue, wow_growth_percentage — ordered by year, week_num.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: