SQL Filter by Salary and Name | Dataford Interview Questions

Your question is SQL Filter by Salary and Name. Start with the requirements and the two tables on the right.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem

Collegedunia needs an employee list for an internal compensation review. Write a PostgreSQL query that returns employees whose names begin with S and whose salaries fall within a specified inclusive range.

Use a salary range from ₹60,000 through ₹100,000, and include the employee's department name by joining the employee and department records.

Requirements

Return the employee ID, full name, salary, and department name.
Include only employees whose full_name begins with uppercase S and whose salary is between ₹60,000 and ₹100,000, inclusive.
Exclude employees whose department does not exist in the departments table.
Sort by salary from highest to lowest, then by name alphabetically for ties.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(100)	Employee full name
salary	NUMERIC(10,2)	Annual salary in Indian rupees
department_id	INT	References departments.department_id

departments

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