题解 | 查询下订单用户访问次数？
select user_id
,count(user_id) visit_nums
from (select distinct visit_time
,o.user_id
from order_tb o join visit_tb v on o.user_id=v.user_id
where order_time like "2022-09-02%" and visit_time like "2022-09-02%") t
group by user_id
order by visit_nums desc