怎么优化这个查询语句

Question

表结构
月份， 项目， 姓名， 工资，奖金，补助，借款，房租，罚款
01.20，1，王一，1000.00,100.00,20.00,0.00,102.20,0.00
01.23，1，王二，1100.00,300.00,110.00,0.00,102.20,54.00
01.25，1，王三，900.00,30.00,110.00,0.00,102.20,0.00
01.25，1，张三，1300.00,31.00,110.00,0.00,102.20,0.00
01.19，1，张四，1200.00,31.00,110.00,0.00,102.20,0.00
02.20，2，王一，1200.00,31.00,110.00,0.00,102.20,0.00
现在要查询出来某个项目特定的几个人的工资，奖金，补助（或者是借款，房租，罚款）select Max(MonthTime) MonthTime,Max(FProject ) FProject ,Max(decode(username,'王一',sarlary)),Max(decode(username,'王一',reward)),,Max(decode(username,'王一',append)),Max(decode(username,'王二',sarlary)),Max(decode(username,'王二',reward)),,Max(decode(username,'王二',append)),Max(decode(username,'王三',sarlary)),Max(decode(username,'王三',reward)),,Max(decode(username,'王三',append)),Max(decode(username,'张一',sarlary)),Max(decode(username,'张一',reward)),,Max(decode(username,'张一',append)) from userPay group by FProject order by MonthTime desc
主见是 Fproject,username

Answer 1

select Max(MonthTime),Max(FProject) ,Max(sarlary),Max(reward),append(append) from userPay where username in ('王一','王二','王三','张一') group by FProject order by MonthTime desc