✏️ Code CompletionSQ SQL Hard⚡+35 XP

ROW_NUMBER Window

Complete the window function to number rows per department.

✏️ Fill in the blank

SELECT name, department,
  ROW_NUMBER() OVER (PARTITION ___ department ORDER BY salary DESC) AS rank
FROM employees;