answers to closed questions

0

Please login or register to vote for this query.

(click on this box to dismiss)

Christianity

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
join
(select a.owneruserid as owneruserid, count(a.id) 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 closedq.id = 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

Options:
Switch sites:
loading Hold tight while we fetch your results