SQL 解鎖: 程式碼解析 1

DigNo Ape

·

Follow

5 min read

·

Feb 12, 2025

--

Share

請以口語、白話形式解析以下SQL程式碼並描繪你認為的原資料表([Database].[Schema].[Table] )結構樣貌。

SELECT  
A.[Business_Unit],
A.[Order_Number] ,  
SUM([Sales_Units]) as [Sales_Units],

SUM([Delivery_Expense_Carrier_Mode_1]) as [Delivery_Expense_Carrier_Mode_1],
SUM([Delivery_Expense_Carrier_Mode_2]) as [Delivery_Expense_Carrier_Mode_2],
SUM([Delivery_Expense_Carrier_Mode_3]) as [Delivery_Expense_Carrier_Mode_3],

SUM(CASE WHEN [Fulfillment_Type] IN ('Fulfillment_Center')  THEN [Sales_Units] ELSE 0 END) AS [Sales_Units_Fullfillment_Center],
SUM(CASE WHEN [Fulfillment_Type] IN ('Fulfillment_Center')  THEN [Delivery_Expense_Total] ELSE 0 END) AS [Delivery_Expense_Fullfillment_Center],
  
  SUM(CASE WHEN [Fulfillment_Type] IN ('Vendor_Dropship')  THEN [Sales_Units] ELSE 0 END) AS [Sales_Units_Vendor_Dropship],
SUM(CASE WHEN [Fulfillment_Type] IN ('Vendor_Dropship')  THEN [Delivery_Expense_Total] ELSE 0 END) AS [Delivery_Expense_Vendor_Dropship],
  
  SUM(CASE WHEN  ([Delivery_Expense_Carrier_Mode_1] < 0)  THEN [Sales_Units] ELSE 0 END) AS [Sales_Units_Mode_1],
SUM(CASE WHEN  ([Delivery_Expense_Carrier_Mode_1] < 0)  THEN [Delivery_Expense_Total] ELSE 0 END) AS [Delivery_Expense_Mode_1],

SUM(CASE WHEN  ([Delivery_Expense_Carrier_Mode_2] < 0)  THEN [Sales_Units] ELSE 0 END) AS [Sales_Units_Mode_2],
SUM(CASE WHEN  ([Delivery_Expense_Carrier_Mode_2] < 0)  THEN [Delivery_Expense_Total] ELSE 0 END) AS [Delivery_Expense_Mode_2],

SUM(CASE WHEN…