Pro exercise

Exclude cancelled, keep unknown status

Leave cancelled orders out of the report. In SQL, status <> 'cancelled' is not true for a missing status, so a careless filter also drops orders whose status is unknown. Label them unknown and keep them.

NULL semantics
scope
filters