Neoview SQL Reference Manual (R2.4 SP2)

--- 1 row(s) selected.
• Return the average salary by department:
SELECT deptnum, AVG (salary) AS "AVERAGE SALARY"
FROM persnl.employee
WHERE deptnum < 3000
GROUP BY deptnum;
Dept/Num "AVERAGE SALARY"
-------- ---------------------
1000 52000.17
2000 50000.10
1500 41250.00
2500 37000.00
--- 4 row(s) selected.
340 SQL Functions and Expressions