Pro exercise

The referenced record is incomplete

Invoices need the customer's billing email from the CRM. A customer that doesn't exist and a customer that exists but has no billing email are different problems with different owners, so report them separately.

joins
required fields
referential integrity