Backend Engineer
Find customers who have never ordered.
- 1Your approach
- 2The follow-up
- 3Reflect & learn
THE INTERVIEWER ASKS
The scenario
Given customers(id, name) and orders(id, customer_id, status), write SQL to find customers with no completed orders.
How would you approach it?
Explain your assumptions, your approach, and why you chose it.