Pro exercise

Current rows from a history table

A customer tier table keeps history: closed rows have a valid_to date and the current row has none. Take the current rows only, and when a customer has two open rows (a load bug), keep the latest one and report the other.

history tables
scope
duplicates