On avg how often are answers I give, accepted
Q&A for users of the Magento e-Commerce platform
-- 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