SQL Ranking and Aggregations | Dataford Interview Questions

Describe how you would solve SQL ranking questions and aggregation problems.

Use the supplied employees, departments, and sales tables. Return each employee's completed sales total and position within their department.

Output

One row per employee assigned to a department.
Columns: department_name, employee_id, employee_name, total_sales, and rank_position.
Rank highest totals first, with equal totals sharing a rank. Sort by department, rank, and employee ID.

departments

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

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee name
department_id	INT	Assigned department identifier

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
employee_id	INT	Employee associated with the sale
amount	DECIMAL(10,2)	Sale amount
status	VARCHAR(20)	Sale processing status

Your question is SQL Ranking and Aggregations. 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.