Window Function User Ranking | Dataford Interview Questions

Write a SQL query using window functions to rank users by monthly revenue within each department at Paycom.

Use the provided users, departments, and payments tables. Include users with payment records, assign the same rank to users with equal monthly revenue, and calculate each month independently.

Output

One row per user, department, and month with payment activity
Columns: department_name, revenue_month, user_id, user_name, monthly_revenue, revenue_rank
Order by department name, month, rank, and user ID

Schema

departments

Column	Type	Description
department_idPK	INT	Unique department identifier
department_name	VARCHAR(100)	Department display name

users

Column	Type	Description
user_idPK	INT	Unique Paycom user identifier
user_name	VARCHAR(100)	User display name
department_id	INT	Department assigned to the user

payments

Column	Type	Description
payment_idPK	INT	Unique payment identifier
user_id	INT	User associated with the payment
payment_date	DATE	Date the payment was recorded
amount	NUMERIC(12,2)	Payment revenue amount

Your question is Window Function User Ranking. Start with the requirements and the three 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