Oracle将查询的结果放入一张自定义表中并再查询数据

with AA as(SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,LASTNAME, NUMBEROFDAYSFROM REPORT_PERFORMANCEOFANALYZERWHERE (DTANALYZED IS NULL)UNION ALLSELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,LASTNAME, NUMBEROFDAYSFROM REPORT_PERFORMANCEOFANALYZER REPORT_PERFORMANCEOFANALYZER_1)SELECT TICKETNUMBER, TICKETTYPE, VERSIONNUMBER, STAGENAME, DTANALYZED,GISPROCESSID, PROCESSSTATUS, DTRECEIVED, USERID, USERNAME, FIRSTNAME,LASTNAME, NUMBEROFDAYS,(SELECT COUNT(GISPROCESSID) AS COUNTTICKETS FROM AA) COUNTTICKETSFROM AAORDER BY USERNAME;