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.