What is the average salary of employees who have a commission percentage that is not null?
SELECT department_id ,  AVG(salary) FROM employees WHERE commission_pct != "null" GROUP BY department_id
average salary = AVG(salary); commission percentage that is not null refers to commission_pct IS NOT NULL; grouped by department refers to GROUP BY department_id;