题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
with t as (select user_id, visit_time, leave_time from visit_tb where user_id in (select distinct user_id from order_tb where date(order_time)='2022-09-02' and order_price is not null) and date(visit_time)='2022-09-02' order by user_id) select user_id, count(*) visit_nums from t group by user_id order by visit_nums desc
