Your question is Break Down Marketplace Analysis with CTEs. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are asked to explain how to use a CTE chain to break a complex marketplace analysis into smaller, readable SQL stages. Focus on how you would structure the logic, why each stage exists, and how the approach helps with debugging and maintaining the query.
Marketplace analysis often combines filtering, aggregation, enrichment, and ranking in one workflow. A CTE chain helps you separate those concerns so the query stays understandable as the business logic grows.