Avg length of posts

0

Please login or register to vote for this query.

(click on this box to dismiss)

Audio-Video Production Meta

Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation

select
  p.Id as [Post Link],
  len(p.Body) as Length, 
  p.Id as PostId, 
  p.Score
from
  dbo.Posts as p with (nolock)
where
  p.OwnerUserId = '##UserId##' and
  p.PostTypeId in (1, 2) and
  p.CreationDate >= '##asOf##'
order by
  1 desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results