题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
SELECT
DATE(order_time) AS order_date,
user_id,
COUNT(order_id) AS order_nums,
vip
FROM order_tb
LEFT JOIN uservip_tb USING (user_id)
GROUP BY user_id,order_date,vip
HAVING order_nums > 1
ORDER BY order_nums DESC
查看1道真题和解析