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

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;

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;

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

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