Dataford
Interview QuestionsInterview GuidesExperiencesMock InterviewsPricing
Get started

Reconcile Dashboard and Source Totals

HardSQL · PostgreSQL00:00
Practice interviewer
In session
5 left
00:00

Your question is Reconcile Dashboard and Source Totals. Start with the requirements and the three tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

You need to log in / sign up to run or submit.

Problem

Write a PostgreSQL query to troubleshoot a mismatch between the Synechron dashboard and the source system for daily settled revenue. Return only date-region combinations where the dashboard total differs from the correctly derived source total, and include prior-day difference context for the same region.

Schema

Tables
  • source_transactions
  • accounts
  • synechron_dashboard_daily

What This Tests

  • Filtering source rows to the metric definition
  • Joining transactions to account attributes
  • Aggregating both systems to the same grain
  • Using FULL OUTER JOIN for reconciliation
  • Using LAG to add debugging context
Tablessource_transactionsaccountssynechron_dashboard_daily
Your solutionPostgreSQL
You need to log in / sign up to run or submit.
Run a query to see results