SYNTAX FOR GROUP HAVING ORDER BY

SELECT ... AGRIGATEDFUNCTION() FROM TABLE1, ... WHERE < CONDITION> GROUP BY COL1, COL2... HAVING <AGG> ORDER BY

' FIND SALARY BASED ON EACH DEPARTMENT NUMBER NOTE: THE SAME COLUMN USED THE THE SELECT STATEMENT "DEPTNO" SHOULD BE USED IN THE GROUP BY

SELECT DEPTNO, SUB(SALARY) "TOTAL SALARY"
FROM EMP
GROUP BY DEPTNO

DISPLAY THE NUMBER OF MALES AND FEMALES FROM EACH CITY ' TABLE > CUST > COLUMN GENDER, CITY

SELECT CITY, GENDER, COUNT(*) "NUMBER OF CUSTOMERS"
FROM CUST
GROUP BY CITY, GENDER