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