Which of the following queries will return the data for employees who belong to the department with the highest value of department ID.1 pointSELECT * FROM EMPLOYEES WHERE DEP_ID = ( SELECT MAX(DEPT_ID_DEP) FROM DEPARTMENTS ) SELECT * FROM EMPLOYEES WHERE DEPT_ID_DEP = MAX ( SELECT DEPT_ID_DEP FROM DEPARTMENTS )SELECT * FROM EMPLOYEES WHERE DEP_ID = ( SELECT DEPT_ID_DEP FROM DEPARTMENTS WHERE DEPT_ID_DEP IS MAX )SELECT * FROM EMPLOYEES WHERE DEP_ID = MAX(DEP_ID)

Which of the following queries will retrieve the HIGHEST value of SALARY in a table called EMPLOYEES?1 pointSELECT MOST(SALARY) FROM EMPLOYEESSELECT MIN(SALARY) FROM EMPLOYERSELECT MAX(SALARY) FROM EMPLOYEESSELECT SALARY FROM EMPLOYEES WHERE MAX

Which of the following queries will return the first name of the employee who earns the highest salary?1 pointSELECT FIRST_NAME FROM EMPLOYEES WHERE SALARY IS HIGHESTSELECT FIRST_NAME, MAX(SALARY) FROM EMPLOYEES GROUP BY F_NAMESELECT MAX(SALARY) FROM EMPLOYEESSELECT FIRST_NAME FROM EMPLOYEES WHERE SALARY = ( SELECT MAX(SALARY) FROM EMPLOYEES )

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

we have following relations:employees(employee_id,first_name,last_name,email,salary,department_id)departments(department_id,department_name,location_id)(1) Find the employees who have the highest salary.(2) Display all the employee name along with department name who are working neitherin ‘HR’ Department nor earns more than 50000.2

Evaluate the SQL statement:SELECT a.emp_name, a.sal, a.dept_id, b.maxsal FROM employees a, (SELECT dept_id, MAX(sal) maxsal FROM employees GROUP BY dept_id) b WHERE a.dept_id = b.dept_id AND a.sal < b.maxsal;A. The statement gives an error at line 1. B. The statement gives an error at line 6.C. The statement produces the employee name, salary, department ID, and maximum salary earned in the employee department for all departments that pay less salary than the maximum salary paid in the company.D. The statement produces the employee name, salary, department ID, and maximum salary earned in the employee department for all employees who earn less than the maximum salary in their department.