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

0

Please login or register to vote for this query.

(click on this box to dismiss)

elementary OS Meta

Q&A about the site for developers and users of elementary OS and applications

SET DATEFIRST 1;
select 
  count(text) as numberofcomments 
  ,DATENAME(DW,creationdate) as dayofweek
from comments
where convert(date,creationdate) between '2021-11-01' and '2021-11-07'
group by DATENAME(DW,creationdate)
order by DATEname(dw,creationdate);
--, creationdate

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

Enter Parameters

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