Consider the tables with their respective fields below:employees: emp_id, dept_id, manager_id, last_namedepartments: dept_id, manager_id, dept_name, location_idYou want to create a report displaying employees last names, department names and locations, Which query should you use to create an INNER JOIN?1 point54321 ON e.dept_id = d.dept_id;JOIN departments dFROM employees eSELECT e.last_name, d.dept_name, d.location_id

To create a report displaying employee last names, department names, and locations. Which query should you use to create an equi-join?Select one:a.SELECT e.last_name, d.department_name, d.location_idFROM employees e, departments dWHERE manager_id =manager_id;b.SELECT last_name, department_name, location_idFROM employees , departments ;c.SELECT employees.last_name, departments.department_name,departments.location_id FROM employees e, departments dWHERE e.department_id =d.department_id;d.SELECT e.last_name, d.department_name, d.location_idFROM employees e, departments dWHERE e.department_id =d.department_id;

For the following table:Employees (EmployeeId, EmployeeName, HireDate, Salary, ReportsTo)You want to identify the supervisor to which each employee reports. You write the following query.SELECT e.EmloyeeName AS [EmployeeName], s.EmployeeName AS [SuperVisorName] FROM Employees eYou need to ensure that the query returns a list of all employees and their respective supervisor. Which join clause should you use to complete the query?INNER JOIN Employees s ON e.ReportsTo = s.EmployeeId;INNER JOIN Employees s ON e.EmployeeId = s.EmployeeId;INNER JOIN Employees s ON e.EmployeeId = s. ReportsTo;RIGHT JOIN Employees s ON e. EmployeeId = s. ReportsTo;

Write query for the following.employee(id,name,salary,address)department(d_id,d_name,id)(1) Create a view department_details of department table.(2) To join two existing tables using inner join.(3) To drop a view

Question 2A DEPARTMENTS table contains DEP_NAME, and DEPT_ID_DEP columns and an EMPLOYEES table contains columns called F_NAME and DEP_ID. We want to retrieve the Department Name for each Employee. Which of the following queries will correctly accomplish this?1 pointSELECT D.F_NAME, E.DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE D.DEPT_ID_DEP = E.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES E, DEPARTMENTS D WHERE E.DEPT_ID_DEP = D.DEP_IDSELECT F_NAME, DEP_NAME FROM EMPLOYEES, DEPARTMENTS WHERE DEPT_ID_DEP = DEP_IDSELECT E.F_NAME, D.DEP_NAME FROM EMPLOYEES, DEPARTMENTS

Write queries for the following tables:T1 ( Empno, Ename , Salary, Designation)T2 (Empno, Deptno.)(1) Display the Deptno in which Employee Seeta is working.(2) Display Empno, Ename, Deptno.