The given Query can also be replaced with SELECT name,course_id FROM instructor,teaches WHERE instructor_ID=teaches_ID;
- Select name, course_id from instructor;
- Select course_id from instructor join teaches;
- Select name, course_id from instructor join teaches;
- Select name,course_id from teaches,instructor where instructor_id=course_id
