What does the below query return?

SELECT MAX$($salary$)$

FROM Employee

WHERE Salary NOT IN $($SELECT Max$($Salary$)$ FROM Employee$)$;

Answer choices

Select only one option

The query will return the second highest salary value.

It will return all the salary values apart from the highest salary.

It will return the highest salary.

The query has an error as MAX is being used without including the HAVING clause.