题解 | 查询下订单用户访问次数？

select 
o.user_id,
count(distinct visit_time) as visit_nums 
from  order_tb o 
left join visit_tb v 
on o.user_id = v.user_id 
where o.order_time like '2022-09-02%' 
    and v.visit_time like '2022-09-02%'
group by o.user_id 
order by visit_nums desc;