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 |