SQL Query From Scenario | Dataford Interview Questions

Tell me about a time you were given a data storage scenario and had to write a SQL query to produce a specific output.

For this exercise, use the supplied users and transactions tables. Write a query that returns users with at least two successful transactions.

Output

One row per qualifying user with user_name, successful_transaction_count, and successful_transaction_amount
Include only transactions whose status is SUCCESS
Sort by total amount descending, then user_id ascending for ties

users

Column	Type	Description
user_idPK	INT	Unique user identifier
user_name	VARCHAR(100)	User display name

transactions

Column	Type	Description
transaction_idPK	INT	Unique transaction identifier
user_id	INT	User associated with the transaction
status	VARCHAR(20)	Transaction processing status
amount	NUMERIC(12,2)	Transaction amount

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