SQL> Select deptno,sum(sal) from emp GROUP BY deptno HAVING sum(sal) > 10000;

SQL> select to_char(hiredate,'yyyy') "Year",count() from emp GROUP BY to_char(hiredate,'yyyy') HAVING count() >1;

Select deptno,sum(sal) from emp GROUP BY deptno HAVING count(*)>3;