Skip to main content
Skills
Free
Assessments
My progress
Home
Skills
SQL for Data Analysis (Beginner)
CTEs and Introductory Window Functions
Practice
Free practice · ordering · easy
Practice
Order a CTE query
Place the main CTE parts in written order.
Arrange in the correct order
1. SELECT ... FROM shipped_orders
Move SELECT ... FROM shipped_orders up
Move SELECT ... FROM shipped_orders down
2. )
Move ) up
Move ) down
3. SELECT ... FROM orders WHERE ...
Move SELECT ... FROM orders WHERE ... up
Move SELECT ... FROM orders WHERE ... down
4. WITH shipped_orders AS (
Move WITH shipped_orders AS ( up
Move WITH shipped_orders AS ( down
Submit answer