Take the "unexpected" reputation coming from your answers from last month.
Suppose now you constantly get those, and figure out how much rep per day you are getting for your past work without "working for it" on that given day
Q&A for professionals in medical and allied health fields, students of those professions, related academics, and others with a sound understanding of medicine and healthcare-related sciences
-- How much reputation are you getting from your past work?
-- Take the "unexpected" reputation coming from your answers from last month.
-- Suppose now you constantly get those, and figure out how much rep per day
-- you are getting for your past work
declare @UserId int = ##UserId##;
SELECT @UserId AS [User Link], @UserId AS Id, Reputation, AgeInDays AS AccountAgeInDays,CAST(CAST(RepFromPast AS float)/AgeInDays AS int) AS OldReputationPerDay
SELECT @UserId AS Id, SUM(Reputation) AS RepFromPast
SELECT CASE WHEN VoteTypeId = 2 THEN 10 ELSE -2 END AS Reputation
Votes v JOIN Posts p ON v.PostId=p.Id JOIN Posts parents ON p.ParentId=parents.Id
WHERE p.PostTypeId = 2
AND p.OwnerUserId = @UserId
AND v.VoteTypeId In (2,3)
AND datediff(day, p.CreationDate,v.CreationDate) > 30
AND p.ownerUserId != parents.ownerUserId
) AS RepCounts
) As RepAndUserCount
SELECT Id, Reputation, CONVERT(int, GETDATE() - CreationDate) as AgeInDays
WHERE Users.Id = @UserId
) AS AccountAge