SQL Table Query Challenges

MediumSQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Table Query Challenges. 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.

You need to log in / sign up to run or submit.

Problem

Payactiv needs a salary analysis for its active workforce. Write a PostgreSQL query that identifies employees with the second highest distinct current annual salary.

Requirements

Consider only employees whose employment_status is Active.
Consider only current compensation records with a non-null annual_salary.
Return every employee tied at the second highest distinct salary.
Include the employee ID, employee name, salary, and salary rank, ordered by employee ID.

Schema

employees

Column	Type	Description
employee_idPK	INT	Unique employee identifier
full_name	VARCHAR(100)	Employee's full name
department	VARCHAR(50)	Payactiv department
employment_status	VARCHAR(20)	Current employment status

employee_compensation

Column	Type	Description
compensation_idPK	INT	Unique compensation record identifier
employee_id	INT	Employee associated with the compensation record
annual_salary	NUMERIC(12,2)	Annual salary amount
is_current	BOOLEAN	Whether the compensation record is current

Tablesemployeesemployee_compensation

Your solutionPostgreSQL

You need to log in / sign up to run or submit.

Run a query to see results