mysql 查询每个店铺的总金额和各个状态的总金额

 

查询每个店铺的总金额和各个状态的总金额

SELECT shop_id,sum(amount),sum(if( status = 0,amount,0))  as sum1,sum(if( status = 1,amount,0))  as sum2,sum(if( status = 2,amount,0))  as sum3  FROM `site_order` WHERE 1 GROUP BY `shop_id`