题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select
t2.user_id,
count(t2.user_id) as visit_nums
from visit_tb t1
right join
(select
distinct
user_id
from order_tb
where substr(order_time,1,10)='2022-09-02') t2
using(user_id)
where substr(visit_time,1,10)='2022-09-02'
and substr(leave_time,1,10)='2022-09-02'
group by user_id
order by visit_nums desc
