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 )

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)

What does the following SQL code do?SELECT name, MAX(salary) FROM Employees WHERE salary < (SELECT MAX(salary) FROM employees);Returns the row with the second highest salaryReturns all the rows that are less than the max salaryReturns the row with the highest salary

Write a query to find employees who have the highest salary in each of the departments.Input format :The input tables are already prepopulated, as given in the problem statement.Output format :The output display the name of each department along with the name of the employee who has the highest salary within that department and their respective salary. Order the output by department name as shown below.Refer to the sample output for the column headers.

From the given employee table, write a query to retrieve the total salary and count of employees who have the highest total salary, where the total salary is calculated as the product of months worked and the salary per month.Table: Employee