SELECT count(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id  =  T2.department_id WHERE T1.department_name  =  'engineer'
How many degrees does the engineering department offer?
SELECT count ( * ) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id = T2.department_id WHERE T1.department_name = 'engineer '
select count ( * ) from departments as t1 join degree_programs as t2 on t1 . department_id = t2 . department_id where t1 . department_name = value
How many degrees does the engineering department offer ?