Skip to content

Navigation Menu

Explore
By company size
By use case
By industry
View all solutions
Topics
- AI
- DevOps
- Security
- Software Development
- View all
Explore
- GitHub Sponsors
  Fund open source developers
- The ReadME Project
  GitHub community articles
Repositories
- Enterprise platform
  AI-powered developer platform
Available add-ons
Pricing

Search code, repositories, users, issues, pull requests...

Search

Clear

Search syntax tips

Provide feedback

We read every piece of feedback, and take your input very seriously.

Include my email address so I can be contacted

Saved searches

Use saved searches to filter your results more quickly

Name

Query

To see all available qualifiers, see our documentation.

You signed in with another tab or window. Reload to refresh your session. You signed out in another tab or window. Reload to refresh your session. You switched accounts on another tab or window. Reload to refresh your session.

Dismiss alert

faizanxmulla / sql-portfolio Public

Notifications You must be signed in to change notification settings
Fork 33
Star 145

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Additional navigation options

Code
Issues
Pull requests
Actions
Projects
Security
Insights

Breadcrumbs

sql-portfolio
stratascratch-solutions
Hard

/

9900-median-salary.sql

Copy path

Latest commit

History

4 lines (4 loc) · 126 Bytes

Breadcrumbs

sql-portfolio
stratascratch-solutions
Hard

/

9900-median-salary.sql

File metadata and controls

4 lines (4 loc) · 126 Bytes

1

2

3

4

SELECT department,

PERCENTILE_CONT(0.5) WITHIN GROUP(ORDER BY salary) AS median_salary

FROM employee

GROUP BY 1

Footer

© 2025 GitHub, Inc.

Footer navigation

Terms
Privacy
Security
Status
Docs
Contact

You can’t perform that action at this time.