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

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

Customers

| CustomerID |   Name   |     City      |
|------------|----------|---------------|
|     1      |   John   |   New York    |
|     2      |   Jane   |   Chicago     |
|     3      |   Mark   | Los Angeles   |
|     4      |   Sarah  | San Francisco |
|     5      |  Michael |   Houston     |

Orders

| OrderID | CustomerID |  OrderDate | TotalAmount |
|---------|------------|------------|-------------|
|    1    |     1      | 2022-05-15 |    500      |
|    2    |     2      | 2022-06-20 |    750      |
|    3    |     3      | 2022-06-25 |    1000     |
|    4    |     1      | 2022-07-10 |    300      |
|    5    |     4      | 2022-08-05 |    900      |

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

A)

SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders GROUP BY CustomerID HAVING COUNT(*) >= 2)

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID GROUP BY Customers.CustomerID HAVING COUNT(*) >= 2

SELECT Name FROM Customers JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE COUNT(*) >= 2

D) SELECT Name FROM Customers WHERE CustomerID IN (SELECT CustomerID FROM Orders WHERE COUNT(*) >= 2)