You have the following table named Sales.
You need to return sales data ordered by customer name and date of sale. For each customer, the
most
recent sale must be listed first.
Which query should you use?
A.
SELECT CustomerName,
SalesDate
FROM Sales
ORDER BY CustomerName,
SalesDate;
B.
SELECT CustomerName,
SalesDate
FROM Sales
ORDER BY SalesDate DESC,
CustomerName;
C.
SELECT CustomerName,
SalesDate
FROM Sales
ORDER BY CustomerName,
SalesDate DESC;
D.
SELECT CustomerName,
SalesDate
FROM Sales
ORDER BY CustomerName DESC;