题解 | 查询单日多次下订单的用户信息？

SELECT DATE(order_time) AS order_date	 , o.user_id, count(*) AS order_nums , u.vip
FROM order_tb AS o JOIN  uservip_tb AS u ON o.user_id=u.user_id
GROUP BY  DATE(order_time),o.user_id
HAVING count(*)>1
ORDER BY order_nums DESC