Welcome to your interview.
The question is on your right: Break Down Operations Analysis with CTEs. Take a moment with it first.
Talk your thinking through with me if you like - when you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes). Discussion and graded submissions share your five interviewer interactions, so spend them well.
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.