Which departments get a commission percentage?
select * from employees where commission_pct ! = "null"
How many employees in these departments get a commission percentage?
select count ( * ) from employees where commission_pct ! = "null"
By department, display average salary of employees who get a commission percentage
select department_id, avg ( salary ) from employees where commission_pct ! = "null" group by department_id