Debug Live SQL Errors | Dataford Interview Questions

How would you approach debugging errors in a live SQL query while sharing your screen with an interviewer?

Assume the interviewer provides the supplied schema, data, and query objective. Explain how you would isolate the issue, validate intermediate results, and produce the corrected PostgreSQL query.

Output

One row per account, including accounts without matching posted transactions
Columns: account_id, account_name, posted_transaction_count, and posted_total
Include only transactions whose status is posted; return zero values when none qualify
Order by account_id ascending

Schema

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
account_name	VARCHAR(100)	Account display name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	INT	Account associated with the transaction
status	VARCHAR(20)	Transaction processing status
amount	DECIMAL(10,2)	Transaction amount

Your question is Debug Live SQL Errors. Start with the requirements and the two 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