select count(j.orderNum) as totalCount,sum(j.price/100) as totalSum from commodityBookSellInfo j,commodityBasicInfo i where i.commid = j.commid and j.orderTime > '2019-11-26' and j.orderTime  < '2019-12-25' and j.status in (5,55,555) and j.status in (5,55,555) and i.shopScore>=150000 and i.shopSellNum>=1000 and i.userid in (466093534,479874739,959698288,257373428,258514823,502140193,452019982,408245393,2006377296,260692115,327027615,485573565,458374412,476873246,353204517,470451600,505468527,400464550,984622768,495055279,457311998,97963387,903150048,501766904,1967779168)

select count(orderNum),sum(price/100) from commodityBookSellInfo where sellerid in (466093534,479874739,959698288,257373428,258514823,502140193,452019982,408245393,2006377296,260692115,327027615,485573565,458374412,476873246,353204517,470451600,505468527,400464550,984622768,495055279,457311998,97963387,903150048,501766904,1967779168) and orderTime > '2019-11-26' and orderTime < '2019-12-26' and  status in (5,55,555)


select i.userid,count(j.orderNum) as totalCount,sum(j.price/100) as totalSum from commodityBookSellInfo j,commodityBasicInfo i where i.commid = j.commid and j.orderTime > '2019-11-26' and j.orderTime  < '2019-12-26' and j.status in (5,55,555) and j.status in (5,55,555) and i.shopScore>=150000 group by i.userid having count(j.orderNum) >= 600 and sum(j.price/100) >= 60000

select i.userid from commodityBookSellInfo j,commodityBasicInfo i where i.commid = j.commid and j.orderTime > '2019-11-26' and j.orderTime  < '2019-12-25' and j.status in (5,55,555) and j.status in (5,55,555) and i.shopScore>=150000 group by i.userid having count(j.orderNum) >= 600 and sum(j.price/100) >= 60000


select userid from (select i.userid,count(j.orderNum) as totalCount,sum(j.price/100) as totalSum from commodityBookSellInfo j,commodityBasicInfo i where i.commid = j.commid and j.orderTime > '2019-11-26' and j.orderTime  < '2019-12-26' and j.status in (5,55,555) and j.status in (5,55,555) and i.shopScore>=150000 group by i.userid) where totalCount > 1