SQL - Yıllık bazda yeni süreç ve süreç versiyon sayısı

select distinct l.name as Kutuphane,p.Name as SurecIsmi,
       (case when pv.Version='1.0.0' then 'Yeni' else 'Guncelleme' end) as Durum 
from   wflLibraries l left outer join
       wflProcesses p on p.Library= l.Id left outer join
       wflProcessVersions pv on pv.Process=p.Id
where DATEPART(YEAR,pv.CreateDate)=DATEPART(YEAR,dateadd(Year,-1,Getdate()))
Order By 1,2  

select distinct CompletedBy as Sayi from wflWorkItems 
where DATEPART(YEAR,EndDate)=2019