0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people seeking specific software recommendations

select t.TagName, 
  COUNT(*) as unanswered, 
  total_count.total_count, 
  CAST(COUNT(*) as float)/CAST(total_count.total_count as float) as percent_unanswered
from Tags t
inner join Posts p on p.Tags like CONCAT('%<', t.TagName, '>%')
inner join (
  select t.TagName as Tag, COUNT(*) as total_count
  from Tags t
  inner join Posts p on p.Tags like CONCAT('%<', t.TagName, '>%')
  group by t.TagName
) total_count on total_count.Tag = t.TagName

where p.AnswerCount = 0
group by t.TagName, total_count
having total_count > 50
order by percent_unanswered desc

fork query

edited sep 2 15

created sep 2 15 anonymous