Explain your data query
Given customers and orders, return each customer’s most recent order while retaining customers with no orders. Define a tie-breaker for equal timestamps.
What a strong answer demonstrates
Correct joins, deterministic results, null handling, and a useful index.