题解 | 查询下订单用户访问次数？

SELECT user_id,count(*) AS 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