Q&A about the site for practitioners of the art and science of signal, image and video processing
with cte as ( SELECT p.id, ntile(100) over (order by len(p.body)) percentile FROM posts p INNER JOIN posttags pt ON p.id = pt.postId INNER JOIN tags t ON pt.tagid = t.id where p.posttypeid = 1 and t.tagname = ##tagname:string## ) SELECT cte.percentile, min(len(p.body)) LengthStart, max(len(p.body)) LengthStop, avg(cast(p.score as decimal(10,4))) avgScore, avg(cast(p.answerCount as decimal(10,4))) AvgAnswerCount, avg(cast(p.viewCount as decimal(10,4))) AvgViewCount, avg(cast(p.CommentCount as decimal(10,4))) AvgCommentCount FROM posts p inner join cte on p.id = cte.id group by cte.percentile order by cte.percentile