Q&A about the site for developers and users of elementary OS and applications
SET DATEFIRST 1;
count(text) as numberofcomments
,DATENAME(DW,creationdate) as dayofweek
where convert(date,creationdate) between '2021-11-01' and '2021-11-07'
group by DATENAME(DW,creationdate)
order by DATEname(dw,creationdate);
--where convert(date,creationdate) = '2021-11-07'-- and '2021-11-07'