/* Formatted on 15/03/2022 13:59:44 (QP5 v5.227.12220.39724) */
SELECT *
FROM ( SELECT b.islem,
SUM (a.ucreti) ucreti,
COUNT (CASE WHEN a.fatura_tipi = 0 THEN 1 ELSE NULL END) adet,
EXTRACT (MONTH FROM TO_DATE (a.tarih, 'dd.mm.yyyy')) AS Ay
FROM hastane.islemyap a inner join hastane.islemtipi b on a.kodu=b.kodu
WHERE
A.KODU IS NOT NULL
AND ( (b.grup_kodu BETWEEN 1 AND 29)
OR b.grup_kodu BETWEEN 50 AND 150)
AND a.tarih BETWEEN TO_DATE ('01.06.2021 00:00:00',
'dd.mm.yyyy hh24:mi:ss')
AND TO_DATE ('31.12.2021 23:59:59',
'dd.mm.yyyy hh24:mi:ss')
GROUP BY b.islem, a.tarih) PIVOT (SUM (ucreti) AS Ucreti,
COUNT (adet) AS Adeti
FOR ay
IN (1 AS Ocak_Ayi,
2 AS Subat_Ayi,
3 AS Mart_Ayi,
4 AS Nisan_Ayi,
5 AS Mayis_Ayi,
6 AS Haziran_Ayi,
7 AS Temmuz_Ayi,
8 AS Agustos_Ayi,
9 AS Eylül,
10 AS Ekim_Ayi,
11 AS Kasım_Ayi,
12 AS Aralik_Ayi))