Right replacement of below given Query is : SELECT Name, CourseId  FROM Faculty, Teaches  WHERE FacultyID= TeachesID;OptionsSelect CourseId from Faculty join Teaches;Select Name,CourseId from Teaches,Faculty where FacultyId=CourseId;Select Name, CourseId from Faculty natural join Teaches;Select Name, CourseId from Faculty;

Below query can be replaced by which one of the following?Select name, course_idfrom instructor, teacheswhere instructor_ID= teaches_ID;Select course_id from instructor join teaches;Select name, course_id from instructor natural join teaches;Select name ,course_id from instructor;Select name,course_id from teaches,instructor where instructor_id=course_id;

SELECT DISTINCT LastName, FirstNameFROM Instructors i JOIN Courses c  ON i.InstructorID = c.InstructorIDORDER BY LastName, FirstName ; Write a SELECT statement (Commented as 5A-2 ) that returns the same result set as this SELECT statement, but don’t use a join. Instead, use a subquery in a WHERE clause that uses the  IN

Choose the correct answerWhich of the following command is used to display the departments of the instructor relation?OptionsSelect * from instructor ;Select * from instructor where Dept_name = Finance;Select dept_name from instructor;Select dept_name for instructor where Name=Jackson;

Given two tables Teachers and Courses, which SQL query retrieves the list of teachers along with the names of the courses they are currently teaching?SELECT Teachers.teacher_name, Courses.course_name FROM Teachers LEFT JOIN Courses ON Teachers.teacher_id = Courses.teacher_id;SELECT Teachers.teacher_name, Courses.course_name FROM Teachers INNER JOIN Courses ON Teachers.teacher_id = Courses.teacher_id;SELECT Teachers.teacher_name, Courses.course_name FROM Teachers RIGHT JOIN Courses ON Teachers.teacher_id = Courses.teacher_id;SELECT Teachers.teacher_name, Courses.course_name FROM Teachers CROSS JOIN Courses WHERE Teachers.teacher_id = Courses.teacher_id;

Select ID, name, dept name, salary * 1.1 where instructor;The query given below will not give an error. Which one of the following has to be replaced to get the desired output?*Salary*1.1IDWhereInstructor