What will the following SQL query return? SELECT e.name, d.department_name FROM employees e LEFT JOIN departments d ON e.department_id = d.department_id;Select one:a. Names of employees along with the names of their departments.b. Names of employees along with the IDs of their departments in descending order.c. Names of employees along with the IDs of their departments.d. Names of employees along with their department names.

Evaluate below sql statement SELECT emp_name, department FROM employees WHERE department = 'HR' UNION SELECT contractor_name, department FROM contractors WHERE department = 'IT';Select one:a. Retrieves the names of all employees and contractors from the HR and IT departments.b. Retrieves the names of employees from the HR department and all contractors.c. Retrieves the names of employees and contractors from the HR and IT departments, excluding employees from the IT department and contractors from the HR department.d. Retrieves the names of employees from the HR department and contractors from the IT department.

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

What does this query primarily achieve? Question 3Answera.Retrieves only departments without any employees.b.Retrieves all departments, including those without assigned employees.c.Retrieves only employees without a designated department.d.Retrieves an error due to the improper use of the RIGHT JOIN.

Examine which part of the query will be executed first for the query given below.Select Employee_id,Employee_Name from Employeewhere Department_Name in(Select Department_Name from Employee where Department_name in (‘Sales’,'Marketing’));

What will the following SQL query return? SELECT AVG(salary) AS average_salary FROM employees WHERE department_id IN (SELECT department_id FROM departments WHERE department_name = 'IT');Select one:a. The number of employees in the IT department.b. The total salary of employees in the IT department.c. The highest salary of employees in the IT department.d. The average salary of employees in the IT department.