Q&A for Muslims, experts in Islam, and those interested in learning more about Islam
-- Enter Query Title -- Enter Query Description DECLARE @UserId int = ##userId## SELECt COUNT(v.Id), vt.Name FROM Votes v JOIN VoteTypes vt ON vt.Id = v.VoteTypeId JOIN Posts p ON p.Id = v.PostId WHERE p.OwnerUserId = @UserId AND vt.Name = 'UpMod' GROUP BY vt.Id, vt.Name