Order 資料表經SQL 執行之後的結果如下所示,下列那一項SQL 語法執行後可得到這樣的結果?Order 資料表Order_IDRegion_nameStore_nameQuantity1EastBoston15002EastNew York2503WestLos Angeles3004WestSan Diego700¨執行結果Region_nameTotalEast1750West1000
(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
下列為Java 語法的迴圈,若num 為6,請問執行結果為何?sum = 0;for ( int number = 1; number <= num; number++)sum += number;
(A)21
(B)6
(C)15
(D)10