Split the company into salary quartiles

SQLHard13 min

Your task

Divide the employees with a recorded salary into four bands by pay, highest first, taking equal salaries in alphabetical order of name. Return name, salary and quartile, ordered by quartile then name.

Tables

department
idINTEGERnameTEXT
1Engineering
2Sales
3Design
4Research
employee
idINTEGERnameTEXTsalaryINTEGERdepartment_idINTEGERmanager_idINTEGERhired_onTEXT
1Ada1800001NULL2021-03-01
2Grace165000112022-06-15
3Linus140000112023-01-09
4Mel1200002NULL2020-11-20
5Kay120000242023-04-02
6IvanNULL242024-02-17
More rows not shown