你有如下名为Sales的表。你需要返回销售数据,并按客户名称和销售日期排序。对于每个客户,必须先列出最近的销售。应使用哪个查询()
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