题解 | SQLW24 查询单日多次下订单的用户信息？
WITH t1 AS (
SELECT
DATE (order_time) AS order_date,
user_id,
COUNT(user_id) AS order_nums
FROM order_tb
GROUP BY DATE(order_time),user_id
HAVING order_nums > 1
)
SELECT t1.*,
a.vip
FROM t1
LEFT JOIN uservip_tb a
ON t1.user_id = a.user_id
ORDER BY order_nums DESC;
# 这道题别忘了进行结果的降序排序。
查看4道真题和解析