aylık doktor bazlı doğum sayıları

 select * from (SELECT TO_CHAR(ISY.TARIH,'MM') TARIH,DECODE(ISY.DR,'101','151','152','153','175','196','67','85','168','189','127','201','228','245','270','279','156','164','214','13','14','276','289','261','282','236','267','293','368','294','317','321','356','361','117','347','403','433','379','128','420','426','450','442','456','328','353','377','280','295')DR_ADI,ISY.DR AS DR_KODU,dr.adi_soyadi,IT.ISLEM bolum_adi,SUM(ISY.ADET) SAYI
FROM HASTANE.ISLEMYAP ISY,HASTANE.ISLEMTIPI IT,HASTANE.PROTOKOL P,HASTANE.KURUM K,hastane.dradi dr
WHERE ISY.TARIH BETWEEN to_date('01.01.2025 00:00','dd.mm.yyyy hh24:mi:ss') and to_date('31.12.2025 23:59:00','dd.mm.yyyy hh24:mi:ss')
--AND ISY.GRUP_KODU=250
AND ISY.OZEL_KOD IN ('P619920','P619921','P619930','P619929','P619926','P619910','P619922')
AND ISY.FATURA_TIPI=0
and ISY.dr=dr.dr_kodu
AND ISY.KODU=IT.KODU(+)
AND ISY.PROTOKOL_NO=P.PROTOKOL_NO
AND P.KURUM_NO=K.KURUM_NO(+)
GROUP BY ISY.DR,IT.ISLEM,ISY.TARIH,dr.adi_soyadi)
PIVOT
(
  SUM(SAYI)
  FOR TARIH IN ('01', '02', '03','04','05','06','07','08','09','10','11','12')
)
ORDER BY DR_KODU;