-- 单日多次下单的用户 with t as ( select date(ot.order_time) as order_date, ot.user_id as user_id, count(*) over(partition by user_id, date(ot.order_time)) as order_nums, ut.vip as vip from order_tb ot join uservip_tb ut on ot.user_id=ut.user_id order by ot.user_id,ot.order_time ) selec...