[DERBY-2239] Example of SelectExpression for GROUP BY clause is mistaken

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 10.4.1.3
• Component/s: Documentation
• Environment: http://db.apache.org/derby/docs/dev/ref/rrefselectexpression.html
• Issue & fix info: Patch Available
• Assignee: Jazarine Jamal
• Reporter: Tomohito Nakayama
• Created: 13/Jan/07 10:36
• Updated: 21/Jan/11 17:49
• Resolved: 30/Jan/08 13:42

Description

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)
FROM EMPLOYEE
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.