单选题

现有订单表结构为Orders(id VARCHAR2(64),&...

Question

现有订单表结构为Orders(id VARCHAR2(64), OrderDate DATE, OrderPrice NUMBER, Customer VARCHAR2(50))，下面哪个语句能正确查找所有订单总金额少于2000的客户？

A. SELECT Customer,SUM(OrderPrice) FROM Orders GROUP BY Customer HAVING SUM(OrderPrice)<2000

B. SELECT t.Customer FROM (SELECT Customer, SUM(OrderPrice) sum FROM Orders) t WHERE t.sum<2000

C. SELECT DISTINCT Customer FROM Orders WHERE SUM(OrderPrice)<2000

D. SELECT Customer,SUM(OrderPrice) FROM Orders HAVING SUM(OrderPrice)<2000