with a as( select t1.order_id,t1.product_id,shop_id, date(event_time) as dt from tb_order_detail as t1 join tb_order_overall as t2 on t1.order_id = t2.order_id join tb_product_info as t3 on t1.product_id = t3.product_id ),#创建事件信息表 b as( select dt,product_id,shop_id fr...