Interview Guides
You inherited a spreadsheet and need to audit it for data quality issues before using it in analysis. Write a PostgreSQL query that flags each record as matched, missing_in_source, duplicate_in_sheet, or invalid_amount by comparing the spreadsheet rows to the source system and checking for duplicate sheet entries and non-positive amounts.