Virtual Gate Test Series: Databases - Query Interpretation

Question

The inner query in Q1 will select the employee having max salary from all other employees in all departments(this will return the max salaried employee in the entire company which belongs to dept 5), and outer query will select all employees not in the inner query. Is this interpretation right?

In Q2, inner query gives a list of all salaries of employees in dept 5, and outer query selects those employees from entire company who have salary greater than anyone in dept 5.

Why is the answer Q1 and not Q2? 

Answer 1

Query 1:

Inner query checks for anyone in the department 5 who have a salary greater than the employee selected in the outer query. If no body exists then that particular employee is picked since NOT EXISTS evaluates to be true. (Hence correct.)

Query 2:

Query is checking for using the ANY clause which says that even if a single person has less salary in department 5 than the current person being evaluated then that person is selected which is not the required answer [We will have to use ALL clause instead to get the correct answer .]