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 * from VoteTypes; --select * from PostTypes; select top 20 Id, sum(Score) from ( select UserId as Id, Score from Comments where Userid is not null --where Userid = @UserId union all select OwnerUserId as Id, Score from Posts where OwnerUserId is not null --where OwnerUserId = @UserId ) as w group by Id;