0

Please login or register to vote for this query.

(click on this box to dismiss)

(only users with at least 10 Popular Questions)

Q&A for professional and enthusiast programmers

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

) g order by g.questioncount desc

fork query

edited apr 26 18 RoyiNamir - SqlOnline

created jun 10 10 sth