All questions
Intermediate · SQL · Data quality
Orders pointing to missing customers
Commonly asked: Database testing interviews · ~6 min
Return id and customer_id of orders whose customer_id has no row in customers. Sort by id.
Checking your membership…
More SQL coding questions
- Salary difference from team averageAdvanced · Window functions
- Day-over-day order changeAdvanced · Window functions
- Most active users in the audit logIntermediate · Aggregation
- Deactivated customers who still orderedAdvanced · Data quality