8)
SELECT CUSTID, COUNT(CUSTID) AS 'NUM_ORD' FROM CUSTOMER GROUP BY CUSTID HAVING COUNT(CUSTID)>=3

9)
SELECT ITEMID, SUM(QTY) AS 'Summary' FROM ITEM GROUP BY ITEMID HAVING ITEMID<=5

10)
SELECT ORDID, AVG(ACTUALPRICE) AS 'Average' FROM ITEM GROUP BY ORDID HAVING ORDID = 615 OR ORDID <608


14) SELECT MAX(SAL) AS 'MAX' FROM EMP GROUP BY JOB

15) SELECT JOB FROM EMP GROUP BY JOB HAVING MAX(JOB)>=3000

16) SELECT MIN(SAL) AS 'MIN', MAX(SAL) AS 'MAX', AVG(SAL) AS 'AVERAGE' FROM EMP GROUP BY JOB ##########

17) SELECT DEPTNO, AVG(SAL) AS 'AVERAGE' FROM EMP GROUP BY DEPTNO HAVING AVG(SAL)>2000

18) SELECT COUNT(JOB) AS 'NO OF MANAGERS' FROM EMP GROUP BY JOB HAVING JOB LIKE '%MANAGER%'

19) SELECT DEPTNO, COUNT(JOB) AS 'SUM OF EMPLOYEES' FROM EMP GROUP BY JOB HAVING COUNT(JOB)>3