Database: student_transcripts_tracking
Question: How many degrees does the engineering department have?
SQL:
SELECT count(*) FROM Departments AS T1 JOIN Degree_Programs AS T2 ON T1.department_id  =  T2.department_id WHERE T1.department_name  =  'engineer'