Posts per user

0

Please login or register to vote for this query.

(click on this box to dismiss)

How many posts have individual users created?

Audio-Video Production Meta

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

-- Posts per user
-- How many posts have individual users created?

select NumPosts
From (
select OwnerUserId As [User Link], count(Id) as NumPosts 
from posts p WHERE 
    OwnerUserId is not null Group By OwnerUserId
) q
where NumPosts < 17 
order by NumPosts desc;

Enter Parameters

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