Analyzing Data in SQL | Dataford Interview Questions

Tell me about a time you had limited time to review data and then used SQL to analyze it and reach a conclusion.

For this exercise, use the supplied account and transaction data to produce a concise review conclusion for the specified seven-day period.

Output

One row per account, including accounts with no qualifying transactions
Columns: account_name, transaction_count, failed_count, failure_rate_pct, and review_conclusion
Classify an account as REVIEW when it has at least two transactions and at least 50% failed transactions, NO_ACTIVITY when it has none, and NO_REVIEW otherwise
Sort by account_id ascending

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
occurred_at	DATE	Transaction date
status	VARCHAR(20)	Transaction outcome
amount	DECIMAL(10,2)	Transaction amount

Your question is Analyzing Data in SQL. 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.