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