SQL for Balance Discrepancies | Dataford Interview Questions

Write a SQL query to identify discrepancies between expected and actual user balances after a trade at Gemini. Use the users, expected_balances, and actual_balances tables. Include mismatches and records missing from either balance source.

Output

One row per discrepancy, with user_id, email, trade_id, expected_balance, actual_balance, discrepancy_amount, and status.
Include missing expected or actual balances, and sort by user_id, then trade_id.

Schema

users

Column	Type	Description
user_idPK	INT	Gemini user identifier
email	VARCHAR(255)	User email address

expected_balances

Column	Type	Description
user_idPK	INT	User associated with the expected balance
trade_idPK	INT	Trade identifier
expected_balance	NUMERIC(18,2)	Balance expected after the trade

actual_balances

Column	Type	Description
user_idPK	INT	User associated with the actual balance
trade_idPK	INT	Trade identifier
actual_balance	NUMERIC(18,2)	Balance recorded after the trade

Your question is SQL for Balance Discrepancies. Start with the requirements and the three tables in the Question tab.

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

Problem