CREATE VIEW dbo.[001_PLASIYER_SIRALI_AYLIK_GIDER_KALEM_TOPLAMLARI]
AS
SELECT        ISNULL(PLAS, 'BILINMEYEN') AS PLAS, AY, YIL, GIDER, SUM(TUTAR) AS AYLIK_TOPLAM, COUNT(*) AS SAY
FROM            dbo.[001_PLASIYER_GIDER_LISTESI]
GROUP BY PLAS, AY, GIDER, YIL