Q&A about the site for serious players and enthusiasts of poker
SET DATEFIRST 1;
count(text) as numberofcomments
-- ,datepart(weekday,creationdate) as daynumber
,DATENAME(DW,creationdate) as dayofweek
where creationdate between '2021-11-01' and '2021-11-07'
group by DATENAME(DW,creationdate);
--where convert(date,creationdate) = '2021-11-07'-- and '2021-11-07'