What are the top 5 “Post Titles” with the most comments? Include the “Title” and the record count of


Please login or register to vote for this query.

(click on this box to dismiss)

Academia Meta

Q&A about the site for academics and those enrolled in higher education

--select count(text) as numberofcomments, datepart(weekday,creationdate) as dayofweek
--from comments
--where creationdate between '2021-11-01' and '2021-11-07'
--group by datepart(weekday,creationdate)--, creationdate

select count(text)
from comments
where convert(date,creationdate) = '2021-11-01'-- and '2021-11-07'

Enter Parameters

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