Scenario SQL Question
Row Number for Employee Ranking
Build mastery in Ctes Window with this scenario-based SQL challenge and live execution support.
Problem Statement
Assign a row number to each employee based on their salary in descending order. Show employee name, salary, department name, and row number.
Relevant Tables
employeesdepartments