1

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

select p.CreationDate, p.Id as [Post Link], p.Score, count(b.UserId) as Users, p.Tags from Posts p, Badges b, Votes v  
where v.VoteTypeId=5 
  and v.PostId=p.Id 
  and v.UserId=b.UserId 
  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

view current version

edited nov 7 14

created oct 31 14 jon.doe14699