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

select user_id, count(visit_time) visit_nums
from visit_tb 
where user_id in (select user_id from order_tb where date(order_time) = '2022-09-02')
and date(visit_time) = '2022-09-02' 
group by user_id
order by visit_nums desc;
筛选的先后顺序比较重要