0

Please login or register to vote for this query.

(click on this box to dismiss)

Users with more than 25 questions and less rep than questions

Q&A for anime and manga fans

-- Duncecaps
-- Users with more than 25 questions and less rep than questions

with questions as (
  select OwnerUserId, qty=count(*) from Posts
  where PostTypeId=1
  group by OwnerUserId
)

select Users.Id as [User Link],
questions.qty as [# of Questions],
reputation  from Users
LEFT JOIN questions on OwnerUserId=Users.id
where questions.qty > reputation and questions.qty > 25
ORDER BY reputation / questions.qty

fork query

created nov 3 10 Brad Mace