On avg how often are answers I give, accepted
Q&A for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation
-- What is my accepted answer percentage rate -- On avg how often are answers I give, accepted DECLARE @UserId int = ##UserId## SELECT (CAST(Count(a.Id) AS float) / (SELECT Count(*) FROM Posts WHERE OwnerUserId = @UserId AND PostTypeId = 2) * 100) AS AcceptedPercentage FROM Posts q INNER JOIN Posts a ON q.AcceptedAnswerId = a.Id WHERE a.OwnerUserId = @UserId AND a.PostTypeId = 2