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•

Median Employee Salary per Companysql

Relational Database Schema

Median Employee Salary per Company

Write an SQL query to find the rows containing the median salary of each company. If the number of employees in a company is odd, there is 1 median row. If even, there are 2 median rows. ### Schema: `Employee` | Column Name | Type | | :--- | :--- | | id | int | | company | varchar | | salary | int | Return the result table ordered by company and salary.

Tables & Sample Fixtures

Table: Employee

id (int)	company (varchar)	salary (int)
1	A	2341
2	A	341
3	A	15
4	A	15314
5	A	451
6	A	513
7	B	15
8	B	13
9	B	1154
10	B	1345

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•

Median Employee Salary per Companysql

Relational Database Schema

Median Employee Salary per Company

Tables & Sample Fixtures

Table: Employee

id (int)	company (varchar)	salary (int)
1	A	2341
2	A	341
3	A	15
4	A	15314
5	A	451
6	A	513
7	B	15
8	B	13
9	B	1154
10	B	1345

query.sql

Execution Output Result

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