【題組】 ⑵ SELECT COUNT(*) AS SKU_Count, SUM(Price) AS TotalRev, SKU FROMORDER_ITEM GROUP BY SKU HAVING

問題詳情

【題組】 ⑵ SELECT COUNT(*) AS SKU_Count, SUM(Price) AS TotalRev, SKU FROMORDER_ITEM GROUP BY SKU HAVING SUM(Price) = 50;（10 分）

參考答案

答案：A
難度：非常簡單0.988816
統計：A(3006),B(17),C(9),D(8),E(0)

上一篇 : 6.柴油機活塞衝程為3000mm，氣缸直徑為700mm，若其活塞平均運動速率10m/sec，試求其引擎之轉速（rpm）？ (A)80 (B)90 (C)100 (D)110
下一篇 : 【題組】50 According to the passage, what does Sam usually do on weekends?(A) He goes to the movies only