Hard
Window Functions
Pro Challenge
NTILE Salary Quartiles
Divide employees into 4 salary quartiles using NTILE(4). Show employee name, salary, and quartile number. Return columns: salary, quartile, first_name. Order results by: salary DESC) AS quartile FROM employees ORDER BY salary DESC.
Preparing the interactive SQL workspace...