Q&A for computer graphics researchers and programmers
SELECT ROW_NUMBER() OVER (ORDER BY MIN(CreationDate)) rowNumber, COUNT(*) amount, CAST(MIN(CreationDate)AS DATE) date FROM Posts WHERE CreationDate BETWEEN '2008-08-10' and '2008-08-17' GROUP BY CAST(CreationDate AS DATE) ORDER BY MIN(CreationDate)