Highest and Lowest Salary | Dataford Interview Questions

Given a DataFrame, write PySpark code to find the highest and lowest salary without duplicates.

Asked in the technical round stage. For this SQL version, use the provided employee and salary tables and return the distinct salary extremes for recognized employees.

Output

Return exactly one row with columns highest_salary and lowest_salary.
Ignore null salaries and salary records without a matching employee.
Return the highest and lowest salary values, with no duplicate output rows.

Schema

employees

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

salary_records

Column	Type	Description
salary_record_idPK	INT	Unique salary record identifier
employee_id	INT	Employee associated with the salary record
salary	DECIMAL(12,2)	Recorded employee salary

Your question is Highest and Lowest Salary. 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