题解 | 查询下订单用户访问次数？
查询下订单用户访问次数？
https://www.nowcoder.com/practice/32bc1e0fce2343ad934b76a025e09fc5
SELECT
`order_tb`.`user_id`,
count(DISTINCT `visit_time`) AS `visit_nums`
FROM `visit_tb`
JOIN `order_tb` ON `visit_tb`.`user_id`=`order_tb`.`user_id`
WHERE DATE(`visit_time`)='2022-09-02'AND DATE(`order_time`)='2022-09-02'
GROUP BY `visit_tb`.`user_id`
ORDER BY `visit_nums` DESC;