SQL Query: Listing Instructors and Taught Sections (University Schema)

SELECT instructor.ID, instructor.name, section.ID FROM instructor LEFT JOIN teaches ON instructor.ID = teaches.ID LEFT JOIN section ON teaches.course_id = section.course_id AND teaches.sec_id = section.sec_id ORDER BY instructor.ID;