instruction: How many votes do I receive per answer?. On average, how many upvotes do I receive for each answer I give?
response: WITH VotesOnPosts AS (SELECT v.Id AS VoteId, p.Id AS PostId, p.PostTypeId AS PostTypeId, p.OwnerUserId AS UserId, vt.Name AS VoteTypeName FROM Votes AS v INNER JOIN Posts AS p ON v.PostId = p.Id INNER JOIN VoteTypes AS vt ON v.VoteTypeId = vt.Id), Answers AS (SELECT OwnerUserId AS UserId, Id AS PostId FROM Posts WHERE PostTypeId = 2), Counts AS (SELECT (SELECT COUNT(*) FROM VotesOnPosts WHERE VoteTypeName = 'UpMod' AND UserId = @UserID AND PostTypeId = 2) AS TotalUpVotes, (SELECT COUNT(*) FROM Answers WHERE UserId = @UserID) AS TotalAnswers) SELECT TotalUpVotes, TotalAnswers, (CAST(TotalUpVotes AS FLOAT) / TotalAnswers) AS VotesPerAnswer FROM Counts