Two Alten Nederland reporting sources return different values for the same financial metric. Explain how you would investigate the discrepancy with SQL, isolate the root cause, and decide which result should be trusted or how the metric definition should be corrected.
Aligning two sources to the same reporting grainUsing joins to detect missing versus mismatched recordsRebuilding metrics with aggregations and CASE logicCommunicating source-of-truth decisions clearlyKeep the answer practical and SQL-oriented. The interviewer is looking for a structured reconciliation method, not a generic statement about checking dashboards or asking engineering to investigate.