Your question is Resolve Conflicting Revenue Across Sources. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
You are comparing revenue reported by two systems, and the numbers do not match. In finance workflows, this usually means you need to identify the source of truth, quantify the variance, and isolate the records driving the mismatch.
Explain how you would investigate two data sources that report conflicting revenue numbers. In your answer, describe how you would compare the datasets, handle missing or duplicate rows, decide which source should be trusted for reporting, and surface the records that explain the difference.
Keep your answer focused on SQL and data manipulation. The interviewer expects you to discuss reconciliation logic, join strategy, aggregation checks, null handling, and how you would structure a query or workflow to expose the discrepancy clearly.