SQL Query for Matching Salaries

EasySQL · PostgreSQL00:00

Practice interviewer

In session

5 left

00:00

Your question is SQL Query for Matching Salaries. 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

A healthcare technology maintains salary records from its internal compensation system and an external benchmarking feed. Write a PostgreSQL query to find employers present in both sources with the same annual salary.

Requirements

Match rows using both employer_name and annual_salary.
Return each matching employer and salary only once, even when duplicate source records exist.
Exclude employers that exist in only one table or whose salaries differ.
Order results by salary descending, then employer name ascending.

Schema

employer_salary_records

Column	Type	Description
record_idPK	INT	Internal salary record identifier
employer_name	VARCHAR(120)	Employer name
annual_salary	NUMERIC(12,2)	Annual salary amount
role_title	VARCHAR(100)	Role associated with the salary

salary_benchmarks

Column	Type	Description
benchmark_idPK	INT	Benchmark record identifier
employer_name	VARCHAR(120)	Employer name from the benchmark feed
annual_salary	NUMERIC(12,2)	Benchmarked annual salary amount
benchmark_source	VARCHAR(80)	External benchmark source

Tablesemployer_salary_recordssalary_benchmarks

Your solutionPostgreSQL

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

Run a query to see results