0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people interested in statistics, machine learning, data analysis, data mining, and data visualization

select CAST(log(len(Body),10) AS DECIMAL(13,1)) AS LogPostLength, avg(CAST(p.Score AS DECIMAL(10,2))) AS MeanPostScore
from Posts p join Users q on p.OwnerUserId = q.Id
where q.Reputation > 10000 and len(Body)>0
group by CAST(log(len(Body),10) AS DECIMAL(13,1))
order by CAST(log(len(Body),10) AS DECIMAL(13,1)) Asc

fork query

edited oct 24 19 anonymous

created feb 10 19 jon.doe14699