所以我想计算一下在一月份进行交易的买家,交易的总和> = 600000,你们能告诉我确切的语法吗,这是我的语法错误:
select count in (select users_id, total_price_star_member from order_star_member where createdAt >= '2020-01-01' and createdAt < '2020-02-01' group by users_id having sum(total_price_star_member) >= 600000);
关键是我想知道在一月份进行交易并且该交易> = 600000的买方有多少
这是MySQL的正确语法:
select count(*) from (select users_id, sum(total_price_star_member) from order_star_member where createdAt >= '2020-01-01' and createdAt < '2020-02-01' group by users_id having sum(total_price_star_member) >= 600000) inner_query;
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句