SQL Query for High Sales Employees | Dataford Interview Questions

Iris software wants to identify employees whose completed sales exceed the £1,000,000 performance threshold. Write a PostgreSQL query that aggregates qualifying sales by employee and returns every employee above the threshold.

Requirements

Include only sales with status = 'Completed'.
Calculate each employee's total completed sales, ignoring NULL sale amounts through PostgreSQL aggregation behavior.
Return the employee ID, employee name, and total sales for employees whose total exceeds 1000000.
Sort the results from highest total sales to lowest.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Employee's department

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
employee_id	INT	Employee responsible for the sale
sale_amount	NUMERIC(12,2)	Monetary value of the sale
status	VARCHAR(20)	Processing status of the sale

Your question is SQL Query for High Sales Employees. 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