Q&A about the site for serious players and enthusiasts of poker
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'