CREATE TABLE employees (department_id VARCHAR(255), salary INTEGER, commission_pct VARCHAR(255))
display the average salary of employees for each department who gets a commission percentage.
    
SQL: SELECT department_id, AVG(salary) FROM employees WHERE commission_pct <> "null" GROUP BY department_id