Interview Guides
You are given internal order data, partner-reported totals, and discrepancy reason codes. Write a PostgreSQL query that helps investigate a recurring data discrepancy by returning, for each partner and day, the internal order count, internal revenue, partner-reported revenue, the revenue delta, and a discrepancy status that labels rows as match, underreported, overreported, or missing_report. Only include days where the partner reported data or the internal system has orders.
