SQL Query With Filters | Dataford Interview Questions

Equifax Workforce Solutions needs a simple compensation lookup for internal reporting. Write a PostgreSQL query that returns the names of employees whose annual salary is greater than $75,000.

Requirements

Return only the employee name column.
Exclude employees earning exactly $75,000, less than $75,000, or having a NULL salary.
Sort the returned names alphabetically for consistent reporting.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
annual_salary	NUMERIC(10,2)	Annual salary in U.S. dollars
department	VARCHAR(50)	Employee's department

Your question is SQL Query With Filters. Start with the requirements and the one table 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

Equifax Workforce Solutions needs a simple compensation lookup for internal reporting. Write a PostgreSQL query that returns the names of employees whose annual salary is greater than $75,000.

Requirements

Return only the employee name column.
Exclude employees earning exactly $75,000, less than $75,000, or having a NULL salary.
Sort the returned names alphabetically for consistent reporting.

Schema

employees

Column	Type	Description
employee_idPK	INTEGER	Unique employee identifier
employee_name	VARCHAR(100)	Employee's full name
annual_salary	NUMERIC(10,2)	Annual salary in U.S. dollars
department	VARCHAR(50)	Employee's department

Your question is SQL Query With Filters. Start with the requirements and the one table 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.