Your question is Break Down Operations 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 you would use a CTE to structure a multi-step operations analysis in PostgreSQL. Focus on how the query can be broken into named stages so the logic is easier to read, debug, and maintain.
Operations analysis often requires several transformations before the final metric is ready. A CTE can separate those steps into clear blocks instead of hiding them inside nested subqueries.