หลักสูตรเมืองยั่งยืนใดบ้าง ถ้ามี จะเป็นไปตามข้อกำหนดของวิชาเอก ?ไม่จำเป็นต้องใช้ตารางทั้งหมด
What Sustainable Cities courses , if any , will satisfy the PreMajor requirement ?It is not neccessary to use all the tables.
 student_record:  student_id [ int]  course_id [ int]  semester [ int]  grade [ varchar]  how [ varchar]  transfer_source [ varchar]  earn_credit [ varchar]  repeat_term [ varchar]  test_id [ varchar] 
SELECT DISTINCT course.department, course.name, course.number FROM course INNER JOIN area ON course.course_id = area.course_id INNER JOIN program_course ON program_course.course_id = course.course_id WHERE (area.area LIKE '%Sustainable Cities%' OR course.description LIKE '%Sustainable Cities%' OR course.name LIKE '%Sustainable Cities%') AND program_course.category LIKE '%PreMajor%'