Q&A for users of Iota, the open-source cryptocurrency for IoT that does not use a blockchain
DECLARE @UserId int = ##UserId## -- Enter Query Title -- Enter Query Description select x, y, sum(y) over (order by x) z, sum(y) over (order by x rows between unbounded preceding and 1 preceding) g, y*100/sum(y) over (order by x rows between unbounded preceding and 1 preceding) k from ( select dateadd(mm,datediff(mm, 0, CreationDate),0) as x, count(1) as y from Users group by dateadd(mm,datediff(mm, 0, CreationDate),0) ) as w ; /*select top 200 dateadd(mm,datediff(mm, 0, CreationDate),0),CreationDate from Users;*/