0

Please login or register to vote for this query.

(click on this box to dismiss)

Does not count self-answers. Shows users with at least @MinAnswers answers.

Q&A for people who like playing board games, designing board games or modifying the rules of existing board games

select u.id, u.displayname, count(p.posttypeid) as answ,count(p.AcceptedAnswerId) as goodansw from
posts as p
join users u on u.id=p.OwnerUserId
group by u.id, u.displayname, p.posttypeid
having p.posttypeid=2 and count(p.posttypeid)>20

fork query

edited nov 25 anonymous

created may 27 10 interjay