CREATE VIEW dbo.PLAS_CITY_COUNT
AS
SELECT QQ.MAHLAS, COUNT(*) AS ADET FROM
(
(SELECT MAHLAS, CITY  FROM [UNIVERSALDB].[dbo].[PLASIYER_RAPOR_AYLIK_TOPLAM] GROUP BY MAHLAS, CITY)
) QQ GROUP BY QQ.MAHLAS