SQL create a list of Orders (with OrderID, CustomerID and OrderDate) listing every customers newest order Each row in the output should include these three columns: EmailAddress, OrderID, and OrderDate.

the output should only contain the most recent order per customer, then sort the results by the EmailAddress column in ascending sequence.

Orders table has

customerid

orderid

orderdate

customer table has

customerid

emailaddress