SELECT lig_id||';'||gist_pav||';'||lig_pav||';'||COUNT(lig_kodas)
FROM diagnozes, ligos, gydymo_lapai, gydymo_rez_tipai, gydymo_istaigos
WHERE diag_lig_id = lig_id
AND gist_id = gal_gist_id
AND diag_gal_id = gal_id
AND gal_grt_id = grt_id
AND gal_gist_id IN (450,451,452,453,235)
AND grt_id = '9'
AND lig_kodas IN ('I21','I22','I63','I64')
AND gal_pabaigos_data >= TO_DATE('2003.01.01','YYYY.MM.DD')
AND gal_pabaigos_data < TO_DATE('2003.12.31','YYYY.MM.DD')
union all
select count(grt_tipas) as mire from gydymo_rez_tipai where grt_tipas = '2' and grt_koks = 'S'
union all
select count(grt_tipas) as gyvi from gydymo_rez_tipai where grt_tipas = '1' and grt_koks = 'S'
GROUP BY lig_id, gist_pav, lig_pav, lig_kodas, grt_tipas, mire, gyvi
;
spool off
set trimspool off
set termout on
set echo on