| OrderID | CustomerID | OrderDate | TotalAmount |
|---------|------------|------------|-------------|
| 1 | 101 | 2022-05-15 | 500 |
| 2 | 102 | 2022-06-20 | 750 |
| 3 | 103 | 2022-06-25 | 1000 |
| 4 | 101 | 2022-07-10 | 300 |
| 5 | 104 | 2022-08-05 | 900 |
Какой из следующих SQL запросов вернет CustomerID и максимальный TotalAmount среди всех заказов?A)
SELECT CustomerID, MAX(TotalAmount) FROM Orders
B) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = MAX(TotalAmount)
C) SELECT CustomerID, TotalAmount FROM Orders WHERE TotalAmount = (SELECT MAX(TotalAmount) FROM Orders)
D) SELECT CustomerID, MAX(TotalAmount) FROM Orders GROUP BY CustomerID