Scenario SQL Question
Find Salary Percentile Rank for Each Employee
Build mastery in Ranking Nth Value with this scenario-based SQL challenge and live execution support.
Problem Statement
Write a query to calculate the percentile rank for each employee based on salary. Show first_name, salary, and percentile_rank (0-100 scale).
Relevant Tables
employees
SQL Concepts Used in This Scenario
Strengthen your understanding with these targeted learning topics: