0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

select p.Id as [Post Link], count(c.Id)
from Posts p
     join Comments c on (PostId = p.Id)
group by p.Id
having count(c.Id) >= 8
order by min(c.CreationDate) desc;

fork query

created mar 18 15 J. Musser