SQL 查询平均每单天于10000元的会员的订单

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;