Task: Text to Code
Input (English): SQL: SELECT Count ( * ) FROM Departments WHERE department_name = "engineer"
Feedback: Use degree programs table instead of departments table.
Output (English): SELECT count(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id  =  T2.department_id WHERE T1.department_name  =  'engineer'