SELECT id [Post Link] , count(*) [# words] , SUM (count(*...

0

Please login or register to vote for this query.

(click on this box to dismiss)

English Language Learners

Q&A for speakers of other languages learning English

SELECT id [Post Link]
     , count(*) [# words]
     , SUM (count(*)) OVER (ORDER BY Id) [total]
FROM posts 
-- cross join string_split(posts.body,' ') words
WHERE posts.OwnerUserId = 9872
group by id
order by id

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results