0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select
  u.reputation,
  count(*) as num_posts
from
  users as u
    join
  posts as p on u.id = p.owneruserid
    join
  posttypes as pt on p.posttypeid = pt.id
where u.reputation >= 8000
  and pt.name in ('Question', 'Answer')
group by u.reputation
having count(*) < 20
order by count(*) asc;

fork query

edited oct 24 14

created oct 24 14 anonymous