Order資料表經SQL執行之後的結果如下所示,下列那一項..-阿摩線上測驗
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 BY Region_name |
( D )SELECT Region_name, SUM(Total) FROM Order GROUP BY Region_name |