What are the different department ids?
select department_id from employees group by department_id
Of these, which had more than 10 employees with commissions?
select department_id from employees group by department_id having count(commission_pct) > 10