有订单表Orders,它们的数据如下图所示。按天计算每个客户的订单总额,正确的是()
A.
SELECT ID, OrderDate , Count(OrderAmount) from Orders Group by ID, OrderDate
B.
SELECT ID, OrderDate , sum(OrderAmount) from Orders Group by ID, OrderDate
C.
SELECT ID, sum(OrderAmount) from Orders Group by OrderDate
D.
SELECT OrderDate , ID, SUM(OrderAmount) from Orders Group by ID