SchoolabeSchoolabe
CoursesProgramsCompaniesQuizPrepAbout
Schoolabe

Learn, Practice, Ace Coding

ProgramsCompaniesTutorialsPracticeQuizInterview PrepCareer QuestGATE 2026Job Ready
AboutContactCareersBlog
DocumentationAPI ReferenceCommunitySupport
Privacy PolicyTermsRefund PolicyCookie Policy

© 2026 Schoolabe

Course Hub
0% Completed

Row number by salary

IntermediateDB: intro_v1
Description

Assign row number to employees based on salary (highest first).

Mission:Practice the core SQL concept for this chapter.
Investigation:Assign row number to employees based on salary (highest first).
Expected Outcome:Return the correct result set.
Concept tags:
#WINDOW#RANK#ROW_NUMBER#LAG#LEAD
Estimated: 3 minDifficulty: Intermediate
Database Schema
Relationships
No relationships documented.
Tables
employees
idnamedepartmentsalary
Monaco SQL EditorOrderedIntermediate3m
Loading...
SCAN
FILTER
GROUP
SORT
RESULT
Pipeline elapsed: 0ms
Shortcuts: Ctrl/Cmd+Enter run, Ctrl/Cmd+/ comment, Ctrl/Cmd+Shift+F format
#WINDOW#RANK#ROW_NUMBER#LAG#LEAD
Result Summary
Expected: 6
Actual: 0
Needs update
Smart Hint: You returned fewer rows. Check JOIN/WHERE.
Progressive Hints
Hint 1: Follow the prompt carefully.
Run a query to see results.
Tip: Explore table previews first to understand data relationships.