SQL数据集查询报错，提示“错误代码:1301 数据集配置错误 Query: 找不到列 "t" 或”用户定义的函数或聚合 "t.sum"，或者名称不明确。

数据集语句如下：

select t.ssbm as 部门

,t.sjld as 上级领导

,t.ywry as 业务人员

,t.sum(jsjr) as 净收入贡献

,t.sum(gdcb) as 固定成本

,t.sum(sfjl) as 实发奖励

,t.sum(ftcb) as 运营分摊

from(

select a.ssbm as ssbm

,a.sjld as sjld

,a.ywry as ywry

,a.yjsrgx as jsjr

,b.xsgz as gdcb

,c.sqje as sfjl

,d.total as ftcb 

from uf_xsjlsjwh a

left join(select xsname,sum(xsgz)as xsgz from uf_xsyjzb 

where ksdate>='${ksrq}' and ksdate<='${jsrq}' group by xsname)b on b.xsname=a.ywry

left join(select sqr,sum(sqje)as sqje from uf_xsydfy

where sqrq>='${ksrq}' and sqrq<='${jsrq}' group by sqr)c on c.sqr=a.ywry

left join(select cwgsbm,sum(total)as total from uf_cwbbdata

where cwgsdate>='${ksrq}' and cwgsdate<='${jsrq}' group by cwgsbm)d on d.cwgsbm=a.ssbm

where a.ssyfnq>='${ksrq}' and a.ssyfnq<='${jsrq}'

)t

group by t.ssbm,t.sjld,t.ywry