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

订单表table 里有字段 ⽤户uid ⽇期date 订单⾦额amount求:连续三天订单⾦额增⻓在120以上的⽤户uid

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

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