表别名少了逗号

SELECT a.SUM1 + b.SUM2 + c.SUM3 from 

(SELECT SUM(POWER_YEAR) SUM1 FROM BX_REPORT_FORM t

where 1=1

and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'

and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'

AND REPORT_NUMBER = '3')a,

(SELECT SUM(POWER_YEAR) SUM2 FROM BT_REPORT_FORM t

where 1=1

and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'

and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'

AND REPORT_NUMBER = '3')b,

(SELECT SUM(POWER_YEAR) SUM3 FROM BD_REPORT_FORM t

where 1=1

and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'

and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'

AND REPORT_NUMBER = '3')c

~~~

SELECT a.SUM1 + b.SUM2 + c.SUM3 from (SELECT SUM(POWER_YEAR) SUM1 FROM BX_REPORT_FORM twhere 1=1and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'AND REPORT_NUMBER = '3')a,

(SELECT SUM(POWER_YEAR) SUM2 FROM BT_REPORT_FORM twhere 1=1and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'AND REPORT_NUMBER = '3')b,

(SELECT SUM(POWER_YEAR) SUM3 FROM BD_REPORT_FORM twhere 1=1and substr(t.ACCOUNT_YEAR_MONTH,1,4) = '2022'and substr(t.ACCOUNT_YEAR_MONTH,6,2) <= '01'AND REPORT_NUMBER = '3')c