以下哪个 SQL 查询使用了窗口函数 ROW_NUMBER() 来为每个部门按工资降序排序并给出排名？A A SELECT department_id, salary, ROW_NUMBER() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; B SELECT department_id, salary, NTILE(4) OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; C SELECT department_id, salary, DENSE_RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees; D SELECT department_id, salary, RANK() OVER (PARTITION BY department_id ORDER BY salary DESC) AS rank FROM employees;