CREATE VIEW dbo.PLASIYER_SEHIR_YILLARA_GORE_TSI_TOPLAMLARI
AS
SELECT        PDEF2, CITY, TUR, YIL, SUM(TRNET) AS TOPLAM
FROM            dbo.PLASIYER_TSI_LISTESI
WHERE        (PDEF2 IS NOT NULL)
GROUP BY PDEF2, CITY, TUR, YIL