Meta participants as a percentage of main users...

1

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
 b.UserId
into #MetaParticipants
from dbo.Badges as b
union
select
 c.UserId
from dbo.Comments as c
union
select
 p.OwnerUserId
from dbo.Posts as p
union
select
 ph.UserId
from dbo.PostHistory as ph
union
select
 se.OwnerUserId
from dbo.SuggestedEdits as se
union
select
 sev.UserId
from dbo.SuggestedEditVotes as sev
union
select
 v.UserId
from dbo.Votes as v;
-- well, the votes for which we can get a user id...
-- pity we can't get views

create index IDX_MetaParticipants_UserId 
on #MetaParticipants(UserId);

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)) / nullif(sum(u.Reputation), 0), 'p3') as [% Rep]
from StackOverflow.dbo.Users as u  
  left join #MetaParticipants as mp
  on mp.UserId = u.Id;

Enter Parameters

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