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 top 20 concat(year(CreationDate),left('00' + month(CreationDate),2)), count(1) from Users group by concat(year(CreationDate),left('00' + month(CreationDate),2)) order by 1;