select * from orderitems where member_id in(select MEMBER_ID from orderitems group by MEMBER_ID having avg(TOTALPRODUCT) >10000 ) order by orderitems.MEMBER_ID;
SQL 查询平均每单天于10000元的会员的订单
最新推荐文章于 2025-04-16 16:24:41 发布
select * from orderitems where member_id in(select MEMBER_ID from orderitems group by MEMBER_ID having avg(TOTALPRODUCT) >10000 ) order by orderitems.MEMBER_ID;