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 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;