Subqueries and Common Table Expressions
Talk it through with a coach who asks guiding questions and gives hints until you reach the answer. Pass to mark the challenge as completed.
The problem
- medium
- Pro
A colleague wrote a long query with three levels of nested subqueries to find customers whose spending is above the average. Explain what a subquery is, what a common table expression, or with clause, is, and how you'd rewrite the query to be easier to read.
Talk this problem through with an AI coach
This is a Pro challenge. Sign in with Google, then upgrade to start a voice session.