阿摩線上測驗 登入

題組內容

四、請寫出下列 SQL 語法的答案:

⑵ SELECT COUNT(*) AS SKU_Count, SUM(Price) AS TotalRev, SKU FROM ORDER_ITEM GROUP BY SKU HAVING SUM(Price) = 50;(10 分)