CREATE TABLE Degree_Programs (department_id VARCHAR(255)); CREATE TABLE Departments (department_id VARCHAR(255), department_name VARCHAR(255))
How many degrees does the engineering department offer?
    
SQL: SELECT COUNT(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id = T2.department_id WHERE T1.department_name = 'engineer'