Interview Questions Interview Guides Experiences Mock Interviews

Interview Guides

Reconcile Investment Account Breaks | Dataford Interview Questions

All questions/SQL & Data Manipulation

Reconcile Investment Account Breaks

MediumJoinsData WranglingAggregations

Problem

You are given daily position data and posted ledger balances for investment accounts. Write a PostgreSQL query that returns each account and business date where the balances do not tie out, along with the position balance, ledger balance, and the variance between them. Only include dates in January 2024.

Problem

You are given daily position data and posted ledger balances for investment accounts. Write a PostgreSQL query that returns each account and business date where the balances do not tie out, along with the position balance, ledger balance, and the variance between them. Only include dates in January 2024.

Practice SQL

PostgreSQL

Open on desktop for the full SQL editor with syntax highlighting and autocomplete.

Up next

Asana Spa

Reconcile Ledger and Bank BalancesMedium

The Thaddeus Foundation

Reconcile Financial Report DiscrepanciesMedium

AMD

Reconcile ERP and Planning BalancesEasy