What are the names and descriptions of the all courses under the "Computer Science" subject?
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"
courses under 'Computer Science' subject refers to WHERE T2.subject_name = 'Computer Science'; names and descriptions refers to SELECT T1.course_name, T1.course_description; joining of Courses and Subjects tables refers to JOIN Subjects AS T2 ON T1.subject_id = T2.subject_id;