Запросы со скалярными функциями аггрегирования:
(Отметьте один правильный вариант ответа.)
Варианты ответа
SELECT id, last_name, salary + NVL(commission_pct,0) FROM s_empWHERE dept_id BETWEEN 31 AND 35ORDER BY last_name;
SELECT last_name, title, dept_id,SUM(salary) OVER (PARTITION BY title) sum_sal FROM s_emp;
SELECT manager_id, MIN(salary) min_sal, COUNT(id) emp_countFROM s_empWHERE manager_id IS NOT NULLGROUP BY manager_idHAVING min_sal > 1000;(Верный ответ)
SELECT last_name, title, start_date,AVG(salary) OVER (ORDER BY start_date ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) avg_sal FROM s_emp;