Subquery vs CTE Patterns — Practice Questions

2 free SQL challenges on Subquery vs CTE Patterns, auto-graded in the browser. Each states the problem, shows the input and expected output, and explains the answer.

• Orders Above Average Amount — Easy · SQL · +50 XP
• Identifying Users with Purchase Frequency Spikes — Hard · SQL · +200 XP

All challenges · All topics · SQL practice: all SQL problems