SELECT Customers.CustomerID,

Questions is : For each customer (customer id) list the date of the first order they placed and the date of the last order they placed.

This is my code but I can't seem to figure out how to include the FIRST order date as well

(SELECT TOP 1 OrderID FROM Orders WHERE Orders.CustomerID=Customers.CustomerID

ORDER BY OrderDate DESC) AS LastOrderID

FROM Customers;