SELECT
TO_CHAR( EXTRACT(YEAR FROM OBJ_DATUM)) rok,
 IDAS2.dph.DPH_TEXT_HODNOTA AS sazba,
SUM(cen_cena*pob_pocet*dph_hodnota) AS zaplaceno
FROM
  IDAS2.objednavky
  JOIN IDAS2.POLOZKY_OBJEDNAVKY USING(obj_id)
  JOIN IDAS2.PRODUKTY USING (pro_id)
  JOIN IDAS2.ceny USING (pro_id)
  JOIN IDAS2.dph USING (typ_id)
WHERE  IDAS2.objednavky.OBJ_DATUM BETWEEN cen_platna_od AND NVL(cen_platna_do,TO_DATE('1.1.2019', 'DD.MM.YYYY'))  AND obj_datum >= IDAS2.dph.DPH_PLATNE_OD AND obj_datum <= NVL(IDAS2.dph.DPH_PLATNE_DO,TO_DATE('1.1.2019', 'DD.MM.YYYY'))
GROUP BY  DPH_TEXT_HODNOTA,  EXTRACT(YEAR FROM OBJ_DATUM) ;