需求背景：用于分析组合产品出单的概率
需求实现：
1、训练一个组合产品出单概率的模型，入参为SKU，组合数量，产品长，产品宽，产品高，产品重量，分类，输出出单概率
2、训练数据样本的查询
SELECT
a.SKU,
a.Pack_Length,
a.Pack_Width,
a.Pack_Height,
a.PackWeight
INTO #sku
FROM
dbo.RB_Product(NOLOCK) AS a
LEFT JOIN dbo.RB_Product_Admin(NOLOCK) AS b ON a.CustomerID = b.CustomerID AND a.SKU = b.SKU
WHERE a.CustomerID = 1 AND a.IsGroup = 1 AND b.CheckStatus = 1
SELECT
a.GroupSku,
CASE WHEN COUNT(DISTINCT a.SKU) = 1 THEN 'pcs组合' ELSE '多SKU组合' END AS '组合类型'
INTO #grouptype
FROM
RB_Product_GroupSku AS a
GROUP BY
a.GroupSku
SELECT
a.SKU,
ISNULL(e.SkuNum,1) AS '组合数量',
a.Pack_Length,
a.Pack_Width,
a.Pack_Height,
a.PackWeight,
bb.BrowseNodeName as '平台分类',
SUM(CASE WHEN b.SalesPrice > 0 THEN b.GroupProductNum ELSE 0 END ) AS '销量' --防止退款重复计算
FROM
#sku AS a
LEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS b ON b.CustomerID = 1 AND a.SKU = b.GroupSKU AND b.OrderCode != '' AND b.OrderSourceType = 1
--LEFT JOIN dbo.RB_WareHouse(NOLOCK) AS c ON c.CustomerID = 1 AND b.WareHouseID = c.ID
LEFT JOIN #grouptype AS d ON a.SKU = d.GroupSku AND d.组合类型 = 'pcs组合'
LEFT JOIN dbo.RB_Product_GroupSku(NOLOCK) AS e ON d.GroupSku = e.GroupSku
LEFT JOIN E_Product_Amazon_BrowseTree (nolock) bb on a.SKU=bb.SKU and IsMain=1
GROUP BY
a.SKU,
ISNULL(e.SkuNum,1) ,
a.Pack_Length,
a.Pack_Width,
a.Pack_Height,
a.PackWeight,bb.BrowseNodeName