https://dbfiddle.uk/?rdbms=oracle_11.2&fiddle=7f6f0dd0d62a41eb7f1e3f537e0380...
先做TO_DATE呀 TO_DATE(LPAD('1110101',8,'0'),'YYYYMMDD') 轉成正確的日期應該就可以隨便弄了?
試看看 TO_CHAR(SYSDATE - INTERVAL '1911' YEAR(4) , 'fmYYYY/MM/DD' )
group by的欄位不能用別名呀, 另外放在select的欄位要對應到group by的欄位, 沒被group by的欄位必須要被aggregate的函數處理...