UNION ALL on multiple anti-join / NULL-detection patterns to assemble a single audit-finding report. Master tier exercises the production data-engineering pattern: instead of running three separate audits and pasting the results, produce one report with an `audit_finding` label column that distinguishes finding types. Combines LEFT JOIN + IS NULL anti-join with NULL-column detection.