Consider the following SQL statement: SELECT workdept, empno, lastname, salary, RANK() OVER (PARTITION BY workdept ORDER BY salary) AS rank_salary FROM employee...