SELECT DISTINCT t1.uid FROM orders t1, orders t2, orders t3 WHERE t1.uid = t2.uid AND t2.uid = t3.uid AND t1.date = DATE_SUB(t2.date, INTERVAL 1 DAY) AND t2.date = DATE_SUB(t3.date, INTERVAL 1 DAY) AND t3.amount >= t2.amount * 1.2 AND t2.amount >= t1.amount * 1.2

SQL 查询:连续三天订单金额增长 120% 以上的用户 UID

原文地址: https://www.cveoy.top/t/topic/m9fk 著作权归作者所有。请勿转载和采集!

免费AI点我,无需注册和登录