mysql multi count with WHERE

 SELECT COUNT(*) AS item_count,
 reseller_id, count(**WHERE sold=1**) as sold_count
 count(**WHERE refunded=1**) as rrefunded
 FROM store GROUP BY
 reseller_id

SELECT SUM(sold) as sold_count, SUM(refunded) as refund_count FROM store

SELECT 
  reseller_id,
  COUNT(*) AS item_count,  
  sum(case sold when 1 then 1 else 0 end) as sold_count,
  sum(case refunded when 1 then 1 else 0 end) as refunded_count
FROM store
GROUP by reseller_id