题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select
a.user_id,
count(a.user_id) as visit_nums
from
visit_tb as a
where
a.user_id in (
select distinct
b.user_id
from
order_tb as b
where
date (b.order_time) = '2022-09-02'
)
and date (a.visit_time) = '2022-09-02'
group by
a.user_id
order by
visit_nums desc;
查看19道真题和解析