Problem
You are comparing staged invoice data against ERP invoice records used in Valmont Industries finance reporting. Write a PostgreSQL query that surfaces discrepancy patterns by vendor and invoice month, including missing ERP matches, amount mismatches, date mismatches, and duplicate staged invoices.
Schema
Tables
- vendors
- erp_invoices
- staged_invoices
Practicing as: Financial Analyst interview at Valmont IndustriesHi, I'll play your Valmont Industries interviewer for the Financial Analyst role. Answer the question above like we're in the room, and I'll respond the way a real interviewer would.
You are practicing as a guest. Sign up free to run your code against the sample data. Your draft stays right here.
