Q&A about the site for users of TeX, LaTeX, ConTeXt, and related typesetting systems
-- 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;