hi! how many employees are there that get a commission percentage?
select count ( distinct employee_id ) from employees where commission_pct > 0
How many departments have more than ten employees who got a commission?
select count ( * ) from ( select department_id from employees group by department_id having count ( commission_pct ) > 10 )