Window Function SQL Query | Dataford Interview Questions

Write a SQL query using a window function to solve the problem.

Using the supplied users and transactions tables, return each completed transaction belonging to a known user. Exclude transactions with missing amounts. Transactions with equal amounts for the same user must share the same rank.

Output

One row per included transaction.
Columns: user_id, display_name, transaction_id, transaction_amount, and amount_rank.
Sort by user_id, rank ascending, then transaction_id ascending.

Schema

users

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

transactions

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

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