Q&A about the site for academics and those enrolled in higher education
SET DATEFIRST 1
select count(text) as numberofcomments, datepart(weekday,creationdate) as dayofweek
where creationdate between '2021-11-01' and '2021-11-07'
group by datepart(weekday,creationdate)--, creationdate
--where convert(date,creationdate) = '2021-11-07'-- and '2021-11-07'