SQL select case

最新推荐文章于 2025-07-23 17:36:50 发布

原创最新推荐文章于 2025-07-23 17:36:50 发布 · 131 阅读

0 ·

CC 4.0 BY-SA版权

SQL相关专栏收录该内容

1 篇文章

订阅专栏

本文详细解析了特定时间段内，不同供应商ID、商品ID、商家ID下的销售数据，通过条件筛选与分组聚合，揭示了商品分类与销售趋势的关系。分析了包括BestBuy、Replink、Buy.com等知名电商平台的销售表现，提供了对电子商务业务策略制定的参考。

部署运行你感兴趣的模型镜像

select var_id, program_id, case merchant_id
when '200' then 'bestbuy'
when '300' then 'Replink'
when '500' then 'Buy.com'
when '30000' then 'ALMO'
when '30025' then 'BabyAge.com'
when '30050' then 'Bambeco'
when '30225' then 'cooking.com'
when '30060' then 'Bass Pro Shops'
when '30225' then 'Cooking.com'
when '30300' then 'Discount Golf World'
when '30355' then 'DSI Systems'
when '30360' then ' eBags'
when '30455' then ' Petra'
when '30475' then 'Sears'
when '30575' then 'ShoeBuy.com'
when '30585' then 'ShoppersChoice.com'
when '30825' then ' Unbeatable'
when '30830' then 'Mercent'
when '30850' then 'Premco'
when '70000' then 'Koinz'
else merchant_id
end
,count(*) as count from order_line
where create_date<='2011-10-25' and create_date>='2011-06-01' and supplier_id='200' and var_id in('b2s_qa','B2S_LIVE' ) and order_status<>'11'
group by var_id, program_id, merchant_id
order by var_id, program_id, merchant_id