题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
with t1 as(
select
distinct user_id
from order_tb o
where date(order_time) = '2022-09-02'
)
select
v.user_id as user_id,
count(v.info_id) as visit_nums
from t1
inner join visit_tb v
on t1.user_id=v.user_id
where date(v.visit_time) = '2022-09-02'
group by v.user_id
order by visit_nums desc
