mysql统计每类图书的价格总和怎么算

selecti.uid,sum(ifnull(deposit,0)+ifnull(ddeposit,0)+ifnull(money,0))asallmoney

frompw_memberinfoileftjoinpw_membersmonm.uid=i.uidleftjoinpw_memberdatadoni.uid=d.uid

whereifnull(deposit,0)+ifnull(ddeposit,0)+ifnull(money,0)>2000

看一下这个SQL

selectsum(if((sex = 1 and age = 2),1,0)),sum(if((sex = 1 and age = 5),1,0)),sum(if((sex = 1 and age = 10),1,0))from a_test

这个SQL现在就是得出的这个结果

---