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