不挂科搜题免费

问题:

计算每个客户的订单总额,正确的SQL是()

选项

  • SELECT_ID,COUNT(OrderAmount)FROM Orders GROUP BY C_ID

  • SELECT_ID,SUM(OrderAmount)FROM Orders GROUP BY C_ID

  • SELECT_ID,SUM(OrderAmount)FROMOrders D.SELECT

  • SELECT OrderDate,C_ID,SUM(OrderAmount)FROM Order GROUP BY C_ID

  • 答案:

    B.SELECT_ID,SUM(OrderAmount)FROM Orders GROUP BY C_ID