题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
SELECT
DATE(order_time) AS order_date,
o.user_id,
COUNT(order_time) AS order_nums,
vip
FROM order_tb o
JOIN uservip_tb u
ON o.user_id = u.user_id
GROUP BY order_date, user_id, vip
HAVING order_nums > 1
投递快手等公司10个岗位