题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select user_id ,
visit_nums
from (
select user_id ,
count(leave_time) as visit_nums
from visit_tb
where left(leave_time,10)='2022-09-02'
and user_id in (
select distinct user_id
from order_tb
where left(order_time,10)='2022-09-02'
)
group by user_id
) a
order by visit_nums desc
投递科锐国际等公司10个岗位