Q&A for people who want to be financially literate
-- number of questions per day SELECT CONVERT(date, CreationDate) AS Da, Count(*) FROM Posts WHERE PostTypeID = 1 AND AcceptedAnswerId > 0 GROUP BY CONVERT(date, CreationDate) ORDER BY Da DESC;