Scenario SQL Question
Quarter-over-Quarter (QoQ) Sales Growth
Build mastery in Date Operations with this scenario-based SQL challenge and live execution support.
Problem Statement
For 2024, compute revenue per calendar quarter and the percentage growth versus the previous quarter using LAG. Return year, quarter, revenue, prev_quarter_revenue, qoq_growth_pct — ordered by year, quarter.
Relevant Tables
orders
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: