题解 | 查询单日多次下订单的用户信息？
查询单日多次下订单的用户信息？
https://www.nowcoder.com/practice/9958aed1e74a49b795dfe2cb9d54ee12
SELECT
DATE(order_time) AS order_date,
o.user_id,
COUNT(order_id) AS order_nums,
u.vip
FROM order_tb o JOIN uservip_tb u
ON o.user_id = u.user_id
GROUP BY DATE(order_time), o.user_id
HAVING order_nums > 1
ORDER BY order_nums DESC
华为HUAWEI成长空间 647人发布
查看13道真题和解析