• 2022-06-03 问题

    ‍数据表如图所示,列出客户订单总金额大于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

    ‍数据表如图所示,列出客户订单总金额大于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

  • 1