有订单表Orders,它的数据如下图所示。列出客户订单总金额大于3000的数据,正确的是() A: SELECTID,SUM(OrderAmount)FROMORDERSgroupbyIDhavingsum(OrderAmount)>3000 B: SELECTID,SUM(OrderAmount)FROMORDERSwheresum(OrderAmount)>3000 groupbyID C: SELECTID,SUM(OrderAmount)FROMORDERSwheresum(OrderAmount)>3000 D: SELECTID,SUM(OrderAmount)FROMORDERS groupbyID wheresum(OrderAmount)>3000

‍数据表如图所示，列出客户订单总金额大于3000的数据，正确的SQL是________‎‍[img=1101x418]1803c6faf3915a8.png[/img]‎ A: SELECT C_ID,SUM(OrderAmount) FROM Orders GROUP BY C_ID HAVING SUM(OrderAmount)>3000 B: SELECT C_ID,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)>3000 GROUP BY C_ID C: SELECT C_ID,SUM(OrderAmount) FROM Orders WHERE SUM (OrderAmoount)>3000 D: SELECT C_ID,SUM(OrderAmount) FROM Orders GROUP BY C_ID WHERE SUM(OrderAmount)>3000

若按天计算每个客户的订单总金额，正确的SQL是________。[img=1101x418]17de922ac4b9078.png[/img] A: SELECT C_ID,COUNT(OrderPrice)FROM Orders GROUP BY C_ID,OrederDate B: SELECT OrderDate,C_ID,SUM(OrderPrice)FROM Orders GROUP BY OrderDate C: SELECT OrderDate,C_ID,SUM(OrderPrice)FROM Orders GROUP BY OrderDate,C_ID D: SELECT OrderDate,SUM(OrderAmount)FROM Orders GROUP BY OrderDate,C_ID