SELECT count(*) FROM EMPLOYEE group by DEPARTMENT having count(*) > 10
Select count(*) from EMPLOYEE e where e.salary > 1000
select count(*) from TABLE_NAME