0

Please login or register to vote for this query.

(click on this box to dismiss)

plus rep + total question score

Q&A for physical fitness professionals, athletes, trainers, and those providing health-related needs

-- Top 100 most questions asked
-- plus rep + total question score

with UserQuestionCounts as (
    select  OwnerUserId, count(*) as QuestionCount, sum(Score) as TotalQuestionScore
      from  Posts
      where PostTypeId = 1 -- question
        and OwnerUserId is not null
    group by OwnerUserId
)
select  top 100 U.DisplayName, U.Reputation, U.Id, UQC.QuestionCount, UQC.TotalQuestionScore
  from  UserQuestionCounts UQC
  join  Users U
    on  U.Id = UQC.OwnerUserId
order by QuestionCount desc

fork query

created mar 17 11 Rup