Data examination for questions without accepted answers

1

Please login or register to vote for this query.

(click on this box to dismiss)

Steepest part of the curve around 5,000 rep.

Biblical Hermeneutics

Q&A for professors, theologians, and those interested in exegetical analysis of biblical texts

create table #unanswered (QuestionID int primary key, QuestionOwnerAcceptedPercent float)

insert #unanswered 
select top 5000
q.Id as QuestionID, 
-- q.OwnerUserId as QuestionOwnerID,

(SELECT 
  (sum(case when subq.AcceptedAnswerId is not null then 1 else 0 end)*100.0/count(*)) AS AcceptedPercent
FrOM Posts subq
WHERE
subq.PostTypeId = 1 and --question
subq.OwnerUserId = q.OwnerUserId) as QuestionOwnerAcceptedPercent

--,q.Title as Title

fRom Posts q
join Users u on u.Id = q.OwnerUserId
where (select count(*) from Posts a where a.PostTypeId = 2
and a.ParentId = q.Id
and a.Score > 0) = 0

and q.PostTypeId = 1
and CommunityOwnedDate is null
and ClosedDate is null
and q.ParentId is null
and q.Score >= 3
and AcceptedAnswerId is null
and DATEDIFF(day, q.CreationDate, GETDATE()) > 1
and DATEDIFF(month, q.CreationDate, GETDATE()) < 6
and u.Reputation > 500
ORDER BY QuestionOwnerAcceptedPercent DESC;

select top 5000
--row_number() over (ORDER BY us.Reputation ASC) as Row,
--ua.QuestionID as [Post Link],
(us.Reputation / 500) as Rep,
count(*) As "X - Askers rep / 500; Y - Count of questions without answers"

frOm #unanswered ua
join Posts p on ua.QuestionID = p.Id
join Users us on us.Id = p.OwnerUserId  
--group by ua.QuestionID, us.Reputation, p.Weight 
wHere QuestionOwnerAcceptedPercent > 50
and us.Reputation < 100000
group by (us.Reputation / 500)
order by Rep Asc

Enter Parameters

Options:
Switch to meta site
loading Hold tight while we fetch your results