Task: Text to Code
Input (English): SQL: SELECT Avg ( T1.SALARY ) FROM employees AS T1 WHERE T1.EMPLOYEE_ID NOT IN ( SELECT T2.EMPLOYEE_ID FROM job_history AS T2 )
Feedback: Remove step 1 and last part of step 2 , Make sure to find commission pct does not equals to null .
Output (English): SELECT department_id ,  AVG(salary) FROM employees WHERE commission_pct != "null" GROUP BY department_id