SQL for Analysis · 35 min · 250 XP
Capstone: is the website taking over?
Answer a director's question end to end, and say what the number really means.
This is the independent capstone. The editor starts empty and the brief doesn't say which technique to use. Plan the steps first: what one row of each step means, where the months come from, and where the comparison has to happen. Use the earlier lessons as references, and open the hint only once you have a plan.
The chain's director has seen the website's revenue level off and asks: is the website taking over from the stores, or losing ground to them? The answer is a table for 2025 with one row per month, plus a sentence on what it shows. Before you trust your table, reconcile it: the website and stores together should add up to the chain's 2025 revenue of 921,587.
Loading your workspace…