-- Database schema
| Course_Authors_and_Tutors : author_id [ INT ] primary_key , author_tutor_ATB [ TEXT ] , login_name [ TEXT ] , password [ TEXT ] , personal_name [ TEXT ] , middle_name [ TEXT ] , family_name [ TEXT ] , gender_mf [ TEXT ] , address_line_1 [ TEXT ] | Students : student_id [ INT ] primary_key , date_of_registration [ TEXT ] , date_of_latest_logon [ TEXT ] , login_name [ TEXT ] , password [ TEXT ] , personal_name [ TEXT ] , middle_name [ TEXT ] , family_name [ TEXT ] | Subjects : subject_id [ INT ] primary_key , subject_name [ TEXT ] | Courses : course_id [ INT ] primary_key , author_id [ INT ] Courses.author_id = Course_Authors_and_Tutors.author_id , subject_id [ INT ] Courses.subject_id = Subjects.subject_id , course_name [ TEXT ] , course_description [ TEXT ] | Student_Course_Enrolment : registration_id [ INT ] primary_key , student_id [ INT ] Student_Course_Enrolment.student_id = Students.student_id , course_id [ INT ] Student_Course_Enrolment.course_id = Courses.course_id , date_of_enrolment [ TEXT ] , date_of_completion [ TEXT ] | Student_Tests_Taken : registration_id [ INT ] Student_Tests_Taken.registration_id = Student_Course_Enrolment.registration_id , date_test_taken [ TEXT ] , test_result [ TEXT ] |
-- -- Find the names and descriptions of courses that belong to the subject named "Computer Science".

SELECT T1.course_name ,  T1.course_description FROM Courses AS T1 JOIN Subjects AS T2 ON T1.subject_id  =  T2.subject_id WHERE T2.subject_name  =  "Computer Science";