Affects Version/s: None
Fix Version/s: 10.4.1.3
Issue & fix info:Patch Available
There is next example.
– List head count of each department,
– the department number (WORKDEPT), and the average departmental salary (SALARY)
– for all departments in the EMPLOYEE table.
– Arrange the result table in ascending order by average departmental salary.
SELECT WORKDEPT, AVG(SALARY)
GROUP BY WORKDEPT
ORDER BY 1
Comment told that head count of each department is listed, but not exaxtly.
I think count is needed here.