Users by Popular Question ratio

0

Please login or register to vote for this query.

(click on this box to dismiss)

(only users with at least 10 Popular Questions)

Stack Overflow

Q&A for professional and enthusiast programmers

-- Users by Popular Question ratio
-- (only users with at least 10 Popular Questions)
select top 20 * from (
select 
  Users.Id as [User Link],
   
  Q.QuestionCount 
  ,Q2.QuestionCount2 
from Users
inner join  (
  
  select
    OwnerUserId,
    count(Id) as QuestionCount
  from posts
  where PostTypeId = 1
  group by OwnerUserId
) as Q on Users.Id = Q.OwnerUserId

inner join  (
  
  select
    OwnerUserId,
    count(Id) as QuestionCount2
  from posts
  where PostTypeId = 2
  group by OwnerUserId
) as Q2 on Users.Id = Q2.OwnerUserId and Users.Id = Q.OwnerUserId



) f
order by f.[QuestionCount2]desc , f.[QuestionCount] desc

Enter Parameters

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