select fund_acc,
(select ye from fund where t.fund_acc = fund_acc and money_type ='人民币')
+
(select ye from fund where t.fund_acc = fund_acc and money_type ='美元') * 8.2773
+
(select ye from fund where t.fund_acc = fund_acc and money_type ='港币') *1.0611from fund T
group by fund_acc
(select ye from fund where t.fund_acc = fund_acc and money_type ='人民币')
+
(select ye from fund where t.fund_acc = fund_acc and money_type ='美元') * 8.2773
+
(select ye from fund where t.fund_acc = fund_acc and money_type ='港币') *1.0611from fund T
group by fund_acc
sum(case when money_type = '人民币' then ye
when money_type = '美元' then ye*8.2773
when money_type = '港币' then ye*1.0611 end)
from fund group by fund_acc order by fund_acc
sum(case when money_type='人民币' then ye else 0 end)+ ,
sum(case when money_type='美元' then ye else 0 end)*8.2773,
sum(case when money_type='港币' then ye else 0 end)*1.0611
from fund
sum(case when money_type='人民币' then ye else 0 end)+ ,
sum(case when money_type='美元' then ye else 0 end)*8.2773,
sum(case when money_type='港币' then ye else 0 end)*1.0611
from fund
group by fund_acc