总计资料.pptxVIP

Chapter 5 ;-- 程式 5-1: 每年每位客戶所下的訂單總數 SELECT CustomerID, YEAR(OrderDate) AS Order_Year, COUNT(*) AS Order_Count FROM Orders WHERE CustomerID LIKE A% GROUP BY CustomerID, YEAR(OrderDate);;-- 程式 5-2: 每年由某位顧客產生、某位職員處理的訂單總數 SELECT CustomerID, EmployeeID, YEAR(OrderDate) AS Order_Year, COUNT(*) AS Order_Count FROM Orders WHERE CustomerID LIKE A% GROUP BY CustomerID, EmployeeID, YEAR(OrderDate);;-- 程式 5-3: 基本的 CUBE 查詢 SELECT CustomerID, YEAR(OrderDate) AS Order_Year, COUNT(*) AS Order_Count FROM Orders WHERE CustomerID LIKE A% GROUP BY CustomerID, YEAR(Ord