問題詳情

Order資料表經SQL執行之後的結果如下所示，下列那一項SQL語法執行後可得到這樣的結果？


(A)SELECT Region_name, Total FROM Order GROUP BY Quantity

(B)SELECT Region_name, SUM(Total) FROM Order GROUP BY Quantity

(C) SELECT Region_name, SUM(Quantity) AS Total FROM Order GROUP BYRegion_name

(D)SELECT Region_name, SUM(Total) FROM Order GROUP BY Region_name

參考答案

答案：C
難度：適中0.679245
統計：A(5),B(19),C(72),D(10),E(0) #
個人：尚未作答書單：寫錯的題目

內容推薦

內容推薦