Archive Database Step 13: Audit Your Queries

Take every query in your project and, for each, write one sentence saying what one row of the result is. Then run the cross-check on your headline numbers: two routes to the same value, and they must agree. Deliberately introduce one bad row, a NULL foreign key or a duplicate, and confirm which of your queries change and which do not. The ones that did not change but should have are the ones with a hidden inner join or a silent NULL exclusion.