CREATE TABLE students (student_id DECIMAL, date_of_registration TIME, date_of_latest_logon TIME, login_name TEXT, password TEXT, personal_name TEXT, middle_name TEXT, family_name TEXT)
CREATE TABLE courses (course_id DECIMAL, author_id DECIMAL, subject_id DECIMAL, course_name TEXT, course_description TEXT)
CREATE TABLE subjects (subject_id DECIMAL, subject_name TEXT)
CREATE TABLE course_authors_and_tutors (author_id DECIMAL, 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)
CREATE TABLE student_tests_taken (registration_id DECIMAL, date_test_taken TIME, test_result TEXT)
CREATE TABLE student_course_enrolment (registration_id DECIMAL, student_id DECIMAL, course_id DECIMAL, date_of_enrolment TIME, date_of_completion TIME)

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"
SELECT "T1"."course_name", "T1"."course_description" FROM "courses" AS "T1" JOIN "subjects" AS "T2" ON "Computer Science" = "T2"."subject_name" AND "T1"."subject_id" = "T2"."subject_id"