Level of Effort


Please login or register to vote for this query.

(click on this box to dismiss)

Returns the number of characters entered to achieve each reputation point.

Craft CMS Meta

Q&A about the site for administrators, end users, developers and designers for Craft CMS

select top 25
    u.Id as [User Link],
    min(u.Reputation) as Reputation,
    sum(len(p.Body)) as TotalLength,
    count(*) as TotalPosts,
    avg(len(p.Body)) as AvgPostLength,
    (cast(sum(len(p.Body)) as float) / cast(min(u.Reputation) as float)) as PostLengthPerReputation
    Posts p
    inner join Users u ON u.Id = p.OwnerUserId
    p.PostTypeId = 2
    and u.Reputation > 1000
group by
    u.Id, u.DisplayName
order by
    PostLengthPerReputation desc

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results