ABUSIVE ASKERS? : QUESTION ASKERS WHO DON'T ACCEPT ANSWERS (last 6 months)

1

Please login or register to vote for this query.

(click on this box to dismiss)

Users who have ASKED at least 3 questions in the past 6 months and have ACCEPTED Answers on less than half of them (not counting Questions with No Answers.)

Ask Different

Q&A for power users of Apple hardware and software

--users who ask but don't accept, last 6 months

select 
  owneruserid,
  sum(case when posttypeid = 1 then 1 else 0 end ) as [#Asked],
  sum(case when acceptedanswerid is null then 0 else 1 end) as [#Accepted],
  sum(answercount) as [#AnswersForThisUser],
  sum(case when posttypeid = 2 then 1 else 0 end ) as [#AnswersByThisUser]
into #temp from posts
where 
  creationdate >= dateadd(d,-180,getdate())
  and (answercount >0 or posttypeid = 2) --ignore questions without answers
  and posttypeid in (1,2)
group by 
  owneruserid
having 
  sum(case when posttypeid = 1 then 1 else 0 end ) >= 3
  
select
  owneruserid as [User Link],
  [#Asked],
  [#Accepted],
  format(cast([#Accepted] as decimal)/[#Asked] ,'0.0%')as [Accept%],
  [#AnswersForThisUser],
  [#AnswersByThisUser]
from #temp
where 
  cast([#Accepted] as decimal)/[#Asked] < 0.5
order by 
  cast([#Accepted] as decimal)/[#Asked], [#Asked] desc

Enter Parameters

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