Q&A about the site for members of the workforce navigating the professional setting
select top(300) ROUND(POWER( 0.0001 * (12.5-POWER(POWER(4.15-POWER(q.AnswerCount,1.3),2),0.3)) * POWER( (ROUND(SUM(p.Score)/(q.AnswerCount+0.1),2) ),0.9) * POWER(SQUARE(q.AnswerCount),0.4) / 10 * POWER(q.Score,1.2)/5 * POWER(q.ViewCount,0.3) * POWER(SQUARE(q.CommentCount+6),0.25) * SQUARE(40-DATEDIFF(YEAR, q.CreationDate, '2040/12/30'))/10,0.5) ,1) as OVERALL, q.Id as [Post Link], q.OwnerUserId as [User Link], q.Tags, q.CreationDate, DATEDIFF(YEAR, q.CreationDate, '2040/12/30') as PseuAge, SQUARE(40-DATEDIFF(YEAR, q.CreationDate, '2040/12/30'))/100 as AgeNorm, q.Score, POWER(q.Score,1.2)/5 as ScoreNorm, q.ViewCount as Views, POWER(q.ViewCount,0.3) as ViewNorm, q.CommentCount as Comments, ROUND(POWER(SQUARE(q.CommentCount+6),0.25),2) as CommNorm, q.AnswerCount as Answers, 12.5-POWER(POWER(4.15-POWER(q.AnswerCount,1.3),2),0.3) as AnsNorm, ROUND(SUM(p.Score)/(q.AnswerCount+0.1),2) as AnsAve, ROUND(POWER(SQUARE(q.AnswerCount),0.4),2) as AnsVal, ROUND( (12.5-POWER(POWER(4.15-POWER(q.AnswerCount,1.3),2),0.3)) * POWER( (ROUND(SUM(p.Score)/(q.AnswerCount+0.1),2) ),0.9) * POWER(SQUARE(q.AnswerCount),0.4) / 10 ,2) as AnsScore from Posts q inner join Posts p on p.ParentId = q.Id where q.PostTypeId = 1 and q.AcceptedAnswerId is not null and q.Score > 0 and q.ViewCount > 0 and q.AnswerCount < 27 and q.CreationDate > DATEFROMPARTS(##sinceyear?2013##,01,01) and q.CreationDate < DATEFROMPARTS(##untilyear?2025##,12,31) group by q.Id, q.OwnerUserId, q.CommentCount, q.CreationDate, q.Tags, q.Score, q.ViewCount, q.AnswerCount, p.ParentId order by OVERALL desc