SQL для тестировщика on Telegram: “Даны следующие таблицы: Employees +-----------+-…”

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

Employees

+-----------+---------+------------+
| EmployeeID|  Name   | Department |
+-----------+---------+------------+
|     1     |  John   |     HR     |
|     2     |  Jane   |     IT     |
|     3     |  Mark   |     HR     |
|     4     |  Sarah  |     IT     |
|     5     | Michael |  Finance   |
+-----------+---------+------------+

Salaries

+-----------+--------+
| EmployeeID| Salary |
+-----------+--------+
|     1     |  5000  |
|     2     |  6000  |
|     3     |  5500  |
|     4     |  6500  |
|     5     |  7000  |
+-----------+--------+

Какой из следующих SQL запросов отберет имена работников, имеющих зарплату большую или равную 6000?

A)

SELECT Name FROM Employees WHERE Salary > 6000

SELECT Name FROM Employees JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

SELECT Name FROM Employees INNER JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID WHERE Salary >= 6000

D) SELECT Name FROM Employees WHERE Salary >= 6000 JOIN Salaries ON Employees.EmployeeID = Salaries.EmployeeID