Rank Users or Sellers With Window Functions | Dataford Interview Questions

Write a SQL query using window functions to rank users or sellers by performance.

For this exercise, rank all sellers by the total value of their completed orders. Include sellers with no completed orders, and assign the same rank to sellers with equal totals.

Output

One row per seller, with seller_id, seller_name, total_completed_gmv, and performance_rank
Include every seller, including those with no completed orders
Sort by total_completed_gmv descending, then seller_id ascending for ties

Schema

sellers

Column	Type	Description
seller_idPK	INT	Unique seller identifier
seller_name	VARCHAR(100)	Seller display name

orders

Column	Type	Description
order_idPK	INT	Unique order identifier
seller_id	INT	Seller associated with the order
status	VARCHAR(30)	Current order status
order_value	NUMERIC(12,2)	Order merchandise value

Your question is Rank Users or Sellers With Window Functions. 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