SQL Query Interpretation | Dataford Interview Questions

Interpret a SQL statement and explain what it returns.

You are given the SQL text and the referenced tables. Describe the result set precisely, including which rows appear, how they are ordered, and any rows excluded by the logic.

Output

State the result at the same grain as the query output.
List the output columns in order, using the exact column names or aliases from the statement.
Include the ordering rules and any rows excluded from the result.

Schema

accounts

Column	Type	Description
account_idPK	INT	Unique account identifier
member_name	VARCHAR(100)	Member name
segment	VARCHAR(30)	Member segment

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
account_id	INT	Account that made the transaction
transaction_date	DATE	Transaction date
amount	NUMERIC(10,2)	Transaction amount
status	VARCHAR(20)	Transaction status

Your question is SQL Query Interpretation. 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