Question

3) The given Query can also be replaced with_______:

SELECT name, course_id
FROM instructor, teaches
WHERE instructor_ID= teaches_ID;

Answer 1

Answer:

have any doubt in my sql

Answer 2

Answer:

The relevant answer to the question is :

Select name, course_id from instructor join teaches;

Explanation:

in the given question it joins :

• because it has two tables that is joined by matching the first column and the second column by column-column matching.
• the column-column matching provides the user to match the column by column wise editing.

Thus in the given question since it matches through column matching, therefore the answer to question is :

Select name, course_id from instructor natural join teaches;

#SPJ3