0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

select top 100 p.Id as [Post Link],p.CreationDate, p.LastActivityDate, p.Score, p.AnswerCount, p.CommentCount
from Posts p 
join PostTags pt on pt.PostId = p.Id
join Tags t on pt.TagId = t.Id
where TagName = 'azure'
and AcceptedAnswerId is null
and AnswerCount < 1
and ClosedDate is null
order by p.CreationDate desc

view current version

edited jul 31 12

created jul 30 12 Chris Koenig