Data examination for questions without accepted answers


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,

  (sum(case when subq.AcceptedAnswerId is not null then 1 else 0 end)*100.0/count(*)) AS AcceptedPercent
FrOM Posts subq
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

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