SQL Quiz
10 questions · no time limit
0:00
SUBQUERIES AND CTES
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
The
customers table contains every customer. The orders table contains order_id, customer_id, and order_date. A report must show every customer and the number of orders placed during 2025, including customers with zero such orders.Which query correctly structures the calculation with a CTE?
YOUR PROGRESS
10
QUESTIONS
Ready when you are
Answer in any order. Your progress shows here as you go.
QUESTIONS
KEYBOARD
Pick an answer ABCD
Next question ↵→
Previous ←
Flag for review F
Answers save as you go · flagged questions come back at the end