answers to closed questions


Please login or register to vote for this query.

(click on this box to dismiss)


Q&A for committed Christians, experts in Christianity and those interested in learning more

select answers.owneruserid as [User Link],
answers.c as allanswers,
closedanswers.c as closedanswers,
cast(closedanswers.c as float) / answers.c as frac from 
(select owneruserid, count(id) as c from posts where
posttypeid = 2 and year(creationdate) >= 2016
group by owneruserid) as answers
(select a.owneruserid as owneruserid, count( as c from 
(select postid as id from posthistory where posthistorytypeid = 10 and cast(comment as int) > 100 and cast(comment as int) != 101 ) as closedq
join posts as a on = a.parentid
where year(a.creationdate) >= 2016
group by a.owneruserid) as closedanswers
on answers.owneruserid = closedanswers.owneruserid
where closedanswers.c >= 2
order by frac desc;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results