-- Database schema
| Addresses : address_id [ INT ] primary_key , line_1 [ TEXT ] , line_2 [ TEXT ] , line_3 [ TEXT ] , city [ TEXT ] , zip_postcode [ TEXT ] , state_province_county [ TEXT ] , country [ TEXT ] , other_address_details [ TEXT ] | Courses : course_id [ INT ] primary_key , course_name [ TEXT ] , course_description [ TEXT ] , other_details [ TEXT ] | Departments : department_id [ INT ] primary_key , department_name [ TEXT ] , department_description [ TEXT ] , other_details [ TEXT ] | Degree_Programs : degree_program_id [ INT ] primary_key , department_id [ INT ] Degree_Programs.department_id = Departments.department_id , degree_summary_name [ TEXT ] , degree_summary_description [ TEXT ] , other_details [ TEXT ] | Sections : section_id [ INT ] primary_key , course_id [ INT ] Sections.course_id = Courses.course_id , section_name [ TEXT ] , section_description [ TEXT ] , other_details [ TEXT ] | Semesters : semester_id [ INT ] primary_key , semester_name [ TEXT ] , semester_description [ TEXT ] , other_details [ TEXT ] | Students : student_id [ INT ] primary_key , current_address_id [ INT ] Students.current_address_id = Addresses.address_id , permanent_address_id [ INT ] Students.permanent_address_id = Addresses.address_id , first_name [ TEXT ] , middle_name [ TEXT ] , last_name [ TEXT ] , cell_mobile_number [ TEXT ] , email_address [ TEXT ] , ssn [ TEXT ] , date_first_registered [ TEXT ] , date_left [ TEXT ] , other_student_details [ TEXT ] | Student_Enrolment : student_enrolment_id [ INT ] primary_key , degree_program_id [ INT ] Student_Enrolment.degree_program_id = Degree_Programs.degree_program_id , semester_id [ INT ] Student_Enrolment.semester_id = Semesters.semester_id , student_id [ INT ] Student_Enrolment.student_id = Students.student_id , other_details [ TEXT ] | Student_Enrolment_Courses : student_course_id [ INT ] primary_key , course_id [ INT ] Student_Enrolment_Courses.course_id = Courses.course_id , student_enrolment_id [ INT ] Student_Enrolment_Courses.student_enrolment_id = Student_Enrolment.student_enrolment_id | Transcripts : transcript_id [ INT ] primary_key , transcript_date [ TEXT ] , other_details [ TEXT ] | Transcript_Contents : student_course_id [ INT ] Transcript_Contents.student_course_id = Student_Enrolment_Courses.student_course_id , transcript_id [ INT ] Transcript_Contents.transcript_id = Transcripts.transcript_id |
-- -- How many different degree names are offered?

SELECT count(DISTINCT degree_summary_name) FROM Degree_Programs;