8)SELECT CUSTID, COUNT(CUSTID) AS 'NUM_ORD' FROM CUSTOMER GROUP BY CUSTID HAVING COUNT(CUSTID)>=39)SELECT ITEMID, SUM(QTY) AS 'Summary' FROM ITEM GROUP BY ITEMID HAVING ITEMID<=510)SELECT ORDID, AVG(ACTUALPRICE) AS 'Average' FROM ITEM GROUP BY ORDID HAVING ORDID = 615 OR ORDID <60814) SELECT MAX(SAL) AS 'MAX' FROM EMP GROUP BY JOB15) SELECT JOB FROM EMP GROUP BY JOB HAVING MAX(JOB)>=300016) 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)>200018) 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