Explain which two indexes should be created to provide an efficient index nested loop join for the following SQL query: SELECT E.SID, O.cname FROM Enrolled E, Offering O WHERE E.OID = 0.0ID AND O.year = 2017; %3D

Write an SQL query to fetch the different projects available from the EmployeeSalary table.

3. What is the result of the following query? 2select name, dept_namefrom Instructorwhere name like ‘%in%’

Write an SQL query to fetch the EmpId and FullName of all the employees working under Manager with id – ‘986’.

My SQL WORKBENCH **Please note that you may actually use as many tables as you need. You are not limited to use only twotables.Example:SELECT *FROM DEPARTMENTS;SELECT *FROM EMPLOYEES;Now join departments and employees tables.SELECT FIRST_NAME, DEPARTMENT_NAMEFROM EMPLOYEES, DEPARTMENTSWHERE EMPLOYEES.DEPARTMENT_ID = DEPARTMENTS.DEPARTMENT_ID;NOTE: If you omit the join condition, the result will be the Cartesian Product of the two tables. A CartesianProduct joins all rows of the first table with all rows of the second table.That is if the first table has n rows and the second table has m rows, the output will have n*m rows.The following query will produce a Cartesian Product:SELECT FIRST_NAME, DEPARTMENT_NAMEFROM EMPLOYEES, DEPARTMENTS;**When table names are long, qualifying column names might be very time consuming. Usually peopleprefer to use table aliases for this purpose.Example: List the name of all employees who work for 'Purchasing' departmentSELECT E.FIRST_NAME "EMPLOYEE…