Q&A about the site for practitioners, researchers, and students in cognitive science, psychology, neuroscience, and psychiatry
select p.CreationDate, p.Id as [Post Link], p.Score, count(v.UserId) as [Users], p.Tags from Posts p, Badges b, Votes v
and p.Tags like '%'+b.Name+'%'
and p.AnswerCount = 0
and p.ClosedDate is Null
group by p.Id, p.Score, p.CreationDate, p.Tags
order by Users desc