题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select user_id, count(visit_time) visit_nums from visit_tb where user_id in (select user_id from order_tb where date(order_time) = '2022-09-02') and date(visit_time) = '2022-09-02' group by user_id order by visit_nums desc; 筛选的先后顺序比较重要
，继续战！
查看29道真题和解析