Pro exercise

Load a new batch only once

A nightly batch can contain orders that an earlier run already loaded. Skip those so re-running the load never inserts an order twice, then validate the amounts of the genuinely new orders.

idempotence
incremental loads
joins