Что будет выведено в столбце emp?

WITH cte AS ( SELECT 'Marketing' AS department, 50 AS employees, 2018 AS year UNION SELECT 'Marketing' AS department, 10 AS employees, 2019 AS year union SELECT 'Sales' AS department, 35 AS employees, 2018 AS year UNION SELECT 'Sales' AS department, 25 AS employees, 2019 AS year ) SELECT c.*, LAST_VALUE(employees) OVER (PARTITION BY department ORDER BY year) AS emp FROM cte c

Для каждого департамента будет выведено число employees за самый последний год.
В столбце emp будет тоже самое, что и в employees
Без явного указания границ рамки точно нельзя сказать
Ошибку из-за order by

SQL Checkup