firebird

I have the query: WITH STAN_IND AS ( SELECT ro.kod_stanow, ro.ind_wyrob||’ – ‘||ro.LP_OPER INDEKS_OPERACJA, count(*) ILE_POWT FROM M_REJ_OPERACJI ro JOIN M_TABST st ON st.SYMBOL = ro.kod_stanow WHERE (st.KOD_GRST starting with ‘F’ or (st.KOD_GRST starting with ‘T’) ) AND ro.DATA_WYKON>’NOW’-100 GROUP BY 1,2) SELECT S.kod_stanow, count(*) ILE_INDEKS, SUM(ILE_POWT-1) POWTORZEN from STAN_IND […]