SQL Quiz
10 questions · no time limit
0:00
QUERYING DATA
Question 1 of 10
No time limit
Current
Answered
Flagged
Not seen
PASSAGE
The
orders table has columns order_id and customer_id. The customers table has columns customer_id and customer_name. A report uses a LEFT JOIN so that orders without a matching customer remain in the result. It must return exactly order_id, the order row's customer_id labeled ordering_customer_id, and the matched customer name labeled buyer_name.Which query returns the required columns and preserves the order row's customer ID when no customer matches?
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