“This Query can be replaced by which one of the following? SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;”

This Query can be replaced by which one of the following? SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;
Select name, course_id from instructor natural join teaches;
Explanation: Join clause joins two tables by matching the common column.
Select name,course_id from teaches,instructor where instructor_id=course_id;
Select name, course_id from instructor;
Select course_id from instructor join teaches;

Leave a Reply

Your email address will not be published. Required fields are marked *