0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for software engineers working on automated testing, continuous delivery, service integration and monitoring, and building SDLC infrastructure

select CAST((len(Body))/100 AS DECIMAL(10,0)), avg(p.Score)
from Posts p join Users q on p.OwnerUserId = q.Id
where q.Reputation > 20000
group by (len(Body))
order by avg(p.Score) Desc

fork query

edited oct 24 19 anonymous

created feb 10 19 jon.doe14699