题解 | 查询下订单用户访问次数?
查询下订单用户访问次数?
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
select order_tb.user_id ,count(distinct info_id) visit_nums from order_tb join visit_tb on order_tb.user_id = visit_tb.user_id where date(order_time) = '2022-09-02' and date(visit_time) = '2022-09-02' group by 1 order by visit_nums desc