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

-- 请查询2022年9月2日这天下订单的用户的访问次数
-- 要求输出：user_id,visit_nums
-- 注：访问次数定义为用户在该日"访问-离开"则记录1次，输出结果按照访问次数降序排序

-- 处理visit_tb
SELECT user_id, COUNT(info_id) AS visit_nums
FROM visit_tb 
WHERE DATE(visit_time) = "2022-09-02" AND DATE(leave_time) = "2022-09-02"
AND user_id IN (SELECT user_id FROM order_tb WHERE DATE(order_time) = "2022-09-02" )
GROUP BY user_id
ORDER BY visit_nums DESC