หลังจากเรียน HJCS 277 แล้ว มีหลักสูตรใดบ้าง ?ไม่จำเป็นต้องใช้ทุกตาราง
Which courses are available after taking HJCS 277 ?It is not neccessary to use all the tables.
 course_offering:  offering_id [ int]  course_id [ int]  semester [ int]  section_number [ int]  start_time [ time]  end_time [ time]  monday [ varchar]  tuesday [ varchar]  wednesday [ varchar]  thursday [ varchar]  friday [ varchar]  saturday [ varchar]  sunday [ varchar]  has_final_project [ varchar]  has_final_exam [ varchar]  textbook [ varchar]  class_address [ varchar]  allow_audit [ varchar] 
SELECT DISTINCT COURSE_0.department, COURSE_0.name, COURSE_0.number FROM course AS COURSE_0 INNER JOIN course_prerequisite ON COURSE_0.course_id = course_prerequisite.course_id INNER JOIN course AS COURSE_1 ON COURSE_1.course_id = course_prerequisite.pre_course_id WHERE COURSE_1.department = 'HJCS' AND COURSE_1.number = 277