SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10
display those departments where more than ten employees work who got a commission percentage.
SELECT department_id FROM employees GROUP BY department_id HAVING COUNT ( commission_pct ) > 10
select department_id from employees group by department_id having count ( commission_pct ) > value
display those departments where more than ten employees work who got a commission percentage .