SELECT department_id FROM employees GROUP BY department_id HAVING COUNT(commission_pct) > 10
What are the department ids for which more than 10 employees had a commission?
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
What are the department ids for which more than 10 employees had a commission ?