What'd happen if you needed reputation to ask questions?

0

Please login or register to vote for this query.

(click on this box to dismiss)

See http://meta.stackoverflow.com/q/86165/13992 ~ Please mind, this query does not account for bounties or suspensions.

Stack Overflow

Q&A for programmers

-- Enter Query Title
-- Enter Query Description

select
  owneruserid as [User Link],
  Reputation,
  10*(1 + reputation/100) as "Questions allowed",
  count(*) as "Questions asked",
  count(*) -  10*(1 + reputation/100) as "Excess questions"
from posts join users on posts.owneruserid = users.id
where posttypeid = 1
group by OwnerUserId, reputation
having count(*) > 10*(1 + reputation/100)
order by count(*) - 10*(1 + reputation/100) desc

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results
:records returned in :time ms:cached