SourCaPlacement OS

Targeted Campus Assessment Prep

Setting up coding workspace...

Loading problem statement, test cases, and compiler sandbox

SourCaPlacement OS

Targeted Campus Assessment Prep

Loading SourCa...

Synchronizing placement benchmarks & campus recruitment roadmaps

SourCa/ Technical Preparation Platform

Companies Practice Progress College Insights Share Feedback Privacy

SourCa is an independent coding and assessment practice system designed from publicly available interview patterns. Not affiliated with or endorsed by any company.

INDEPENDENT PLATFORM

Practice Directory•

Department Top Three Salariessql

Relational Database Schema

Department Top Three Salaries

Write an SQL query to find the employees who earn in the top three unique salaries in each department. ### Schema: `Employee` | Column Name | Type | | :--- | :--- | | id | int | | name | varchar | | salary | int | | departmentId | int | ### Schema: `Department` | Column Name | Type | | :--- | :--- | | id | int | | name | varchar |

Tables & Sample Fixtures

Table: Employee

id (int)	name (varchar)	salary (int)	departmentId (int)
1	Joe	85000	1
2	Henry	80000	2
3	Sam	60000	2
4	Max	90000	1
5	Janet	69000	1
6	Randy	85000	1
7	Will	70000	1

Table: Department

id (int)	name (varchar)
1	IT
2	Sales

query.sql

Execution Output Result

Click 'Run & Verify Query' to test your SQL against the sample test fixture.

SourCaPlacement OS

Targeted Campus Assessment Prep

Setting up coding workspace...

Loading problem statement, test cases, and compiler sandbox

Practice Directory•

Department Top Three Salariessql

Relational Database Schema

Department Top Three Salaries

Tables & Sample Fixtures

Table: Employee

id (int)	name (varchar)	salary (int)	departmentId (int)
1	Joe	85000	1
2	Henry	80000	2
3	Sam	60000	2
4	Max	90000	1
5	Janet	69000	1
6	Randy	85000	1
7	Will	70000	1

Table: Department

id (int)	name (varchar)
1	IT
2	Sales

query.sql

Execution Output Result

Click 'Run & Verify Query' to test your SQL against the sample test fixture.