Which keyword must be used in below query to rename the field name?SELECT name ____ instructor_name, course_idFROM instructor, teacherWHERE instructor.ID= teacher.ID;AsJoinFromRename

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;

Write a query to rename table 'station' to 'station_details'.

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

Write a query to rename the table members to 'members_details'

Examine the description of the STUDENTS table: STD_ID NUMBER (4)COURSE_ID VARCHAR2 (10)START_DATE DATEEND_DATE DATETo rename column end_date as EOD which command should be executed?Alter table STUDENTS rename column end_date to EOD;Rename column end_date to EOD;You can not change column name after table is createdAlter table STUDENTS rename end_date to EOD;