Scenario: In a Orders table with columns CustomerID, ProductID, and OrderDate, which SQL query would retrieve the earliest order date for each customer?

Context:

Orders Table Columns:

OrderID

CustomerID

ProductID

OrderDate

A

SELECT CustomerID, MIN$($OrderDate$)$ FROM Orders GROUP BY CustomerID;

B

SELECT $*$ FROM Orders GROUP BY OrderDate, CustomerID;

C

SELECT CustomerID, MAX$($OrderDate$)$ FROM Orders GROUP BY OrderDate;

D

SELECT CustomerID, MIN$(*)$ FROM Orders GROUP BY OrderID;