少楊

查詢每個店鋪的總金額和各個狀態的總金額

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`