SQL: Find Missing Scans
Find expected HUs that do not exist in the scanned table.
Before you answer
State the key, the expected grain and one edge case you would test. The goal is not only to get a result, but to know why it is correct.
Hint
Use NOT EXISTS or LEFT JOIN + IS NULL.
Completion is stored only in this browser.