Consider the following example.
Example:
A University name BITS has maintained the two relations to store the information about the faculty table and Teaches table. The faculty table stores the faculty_id (faculty_id has the unique id of faculty in the whole university) and faculty_name. The Teaches table stores the Course_id, Course_Name, and faculty_id. So the university admin department prints the faculty_name and Course_Name.
Which query prints the faculty_name and teaching subject as Course_Name.?
Select faculty_name
From faculty, Teaches
Where faculty.faculty_id =Teaches.faculty_id;
Select faculty_name, Course_Name
From faculty, Teaches
Where faculty.faculty_id =Teaches.faculty_id;
Select faculty_name, Course_Name
From faculty, Teaches;
Select faculty_name
From faculty, Teaches;