![](https://cos-cdn.shuashuati.com/pipixue-wap/2020-1230-1107-56/ti_inject-812ce.png)
有订单表Orders,它的数据如下图所示。列出客户订单总金额大于3000的数据,正确的是()
A.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID having sum(OrderAmount)>3000
B.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000 group by ID
C.
SELECT ID,SUM(OrderAmount) FROM ORDERS where sum(OrderAmount)>3000
D.
SELECT ID,SUM(OrderAmount) FROM ORDERS group by ID where sum(OrderAmount)>3000