0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

select top 1 t.Id, count(*) as 'Unanswered'

from Posts p 
join Tags t on p.Tags = '%<'+t.TagName+'>%'

where PostTypeId = 1
and p.AnswerCount <1

group by t.Id
order by t.Id asc

fork query

edited may 18 19 anonymous

created feb 12 19 Glorfindel