分条件计算总数

SELECT     -- SUM(case when TransactionType='账户支出' then AmoutPrice else 0 END) as am,   -- SUM(case when TransactionType='在线支出' then OnlinePrice else 0 END) as om ,   -- SUM(case when TransactionType='账户+在线' then price else 0 END) as aom ,   -- SUM(case when PayPlatform=100 then AmoutPrice else 0 END) as aaom ,   SUM(case when PayPlatform=1 then OnlinePrice else 0 END) as pam,   SUM(case when PayPlatform=2 then OnlinePrice else 0 END) as wom ,      SUM(case when Type='购买版权' then price else 0 END) as bm,   SUM(case when Type='PVMode' then price else 0 END) as sm ,   SUM(Price)as allmfrom us_c c INNER JOIN us_s u on c.UserId=u.Id where u.UserState<>2 AND c.AddTime>'2017-5-5' and c.AddTime<'2017-8-18' ORDER BY c.AddTime DESC;