Hello everyone,
I wrote this statement and i don't know why i get an error, please advice anyone.
SELECT MAX(AVG(salary)),MIN(AVG(salary)), department_id
FROM employees
GROUP BY department_id
ERROR:
ORA-00937: not a single-group group function
thanks