计算每天、每个直播间下产品占当天该直播间总销售占比(注：当天直播间数据超过四条时，去掉最大和最小值再计算，否则不做过滤直接计算)

原创

已于 2025-08-15 17:46:32 修改 · 489 阅读

7 ·

CC 4.0 BY-SA版权

文章标签：

#数据库 #sql

于 2025-05-10 20:13:51 首次发布

with t1 as (
select '87362763232' as dy_account_id,'8100012' as product_cd,'109￥' as pay_amt,'2025-02-19 10:00:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100012' as product_cd,'199￥' as pay_amt,'2025-02-19 01:32:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100014' as product_cd,'99￥' as pay_amt,'2025-02-19 09:32:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100014' as product_cd,'80￥' as pay_amt,'2025-02-19 11:32:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100014' as product_cd,'45￥' as pay_amt,'2025-02-19 11:32:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100012' as product_cd,'299￥' as pay_amt,'2025-02-19 11:32:33' as pay_time
union all
select '87362763232' as dy_account_id,'8100012' as product_cd,'89￥' as pay_amt,'2025-02-19 11:32:33' as pay_time
union all
select '6045283728