SQL для тестировщика

Дана следующая таблица:



Employees



| EmployeeID | Name | Department | Salary | Age |

|------------|-----------|------------|---------|-----|

| 1 | John | HR | 5000 | 30 |

| 2 | Jane | IT | 6000 | 28 |

| 3 | Mark | HR | 5500 | 35 |

| 4 | Sarah | IT | 6500 | 32 |

| 5 | Michael | Finance | 7000 | 29 |



Какой из следующих SQL запросов вернет имена сотрудников, имеющих зарплату выше, чем самая высокая зарплата в департаменте "Finance"?



A) SELECT Name FROM Employees WHERE Salary > MAX(SELECT Salary FROM Employees WHERE Department = 'Finance')



B) SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees WHERE Department = 'Finance')



C) SELECT Name FROM Employees WHERE Salary > (SELECT MAX(Salary) FROM Employees GROUP BY Department HAVING Department = 'Finance')



D) SELECT Name FROM Employees WHERE Salary > MAX(Salary) AND Department = 'Finance'