Meta participants as a percentage of main users...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Robotics Meta

Q&A about the site for professional robotic engineers, hobbyists, researchers and students

with metaUsers (userId) as
(
	select distinct *
	from (
        --select UserId from dbo.Badges
		--union
        select UserId from dbo.Comments
		union
		select OwnerUserId from dbo.Posts
		union
		select UserId from dbo.PostHistory
		union
		select OwnerUserId from dbo.SuggestedEdits
		union
		select UserId from SuggestedEditVotes
		union
		select UserId from dbo.Votes
	) a where UserId is not null
)

select
 format(1.0 * count(mp.UserId) / nullif(count(*), 0), 'p3') as [% Users]
,format(1.0 * sum(iif(mp.UserId is null, 0, u.Reputation-1)) / nullif(sum(u.Reputation-1), 0), 'p3') as [% Rep]
from StackOverflow.dbo.Users as u  
  left join metaUsers as mp
  on mp.UserId = u.Id;

Enter Parameters

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