select, count(users.no_of_comments) as comments,...


Please login or register to vote for this query.

(click on this box to dismiss)

Network Engineering

Q&A for network engineers

select, count(users.no_of_comments) as comments,cast(c.creationdate as date)
(select top 50, p.commentcount as no_of_comments
from posts p
where year(p.CreationDate) = year(getdate())-1
group by,p.commentcount
order by no_of_comments desc) as users
inner join comments c on = c.postid
group by,cast(c.creationdate as date)

Enter Parameters

Switch to meta site
loading Hold tight while we fetch your results