Task: Text to Code
Input (English): How many degrees does the engineering department have?
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'