福清核电有限公司官网:数据库中包括两个表salesperson和orders，表定义

如下：
CREATE TABLE Salesperson
(SalesPersionID int IDENTITY(1,1) NOTNULL PRIMARY KEY NONCLUSTERED,
RegionID int NOTNULL,
LastName varchar(30) NULL,
FirstName varchar(30) NULL,
MiddlName varchar(30) NULL,
AddressID int NULL)

CREATE TABLE Orders
(OrderID int IDENTITY(1,1) NOTNULL PRIMARY KEY NONCLUSTERED,
SalesPersonID int NOTNULL,
RegionID int NOTNULL,
OrderDate datetime NOTNULL,
OrderAmount money NOTNULL)
现在想得到2003年4月15日每个销售人员最高销售订单信息，信息中包含以下字段：Last Name、First Name、 Order Date、Order Amount。
（ ）可以实现此功能。(选择一项)
A、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
INNER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
AND OrderAmount in(select MAX(OrderAmount) from orders)
B、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
LEFT OUTER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID AND o.OrderDate=’04/15/2003’
GROUP BY s.LastName,s.FirstName,o.OrderDate
C、SELECT s.LastName,s.FirstName,o.OrderDate,OrderAmount
FROM SalesPerson AS s
LEFT OUTER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
AND OrderAmount in(select MAX(OrderAmount) from orders)
D、SELECT s.LastName,s.FirstName,o.OrderDate,MAX(OrderAmount)
FROM SalesPerson AS s
INNER JOIN Orders AS o
ON o.SalesPersonID=s.SalesPersonID
WHERE o.OrderDate=’04/15/2003’
GROUP BY s.LastName,s.FirstName,o.OrderDate,o.OrderID