Прокачиваем SQL — must have skill для хорошего тестировщика.
От создателей @godoftesting
По всем вопросам: @anothertechrock
Post #143
1.57K
Дана следующая таблица:
Employees
A)
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'- 👍 9
