instruction: select count(*), Date(CreationDate) from posts group by Date(CreationDate) order by CreationDate.
response: SELECT COUNT(*), DAY(CreationDate), MONTH(CreationDate), YEAR(CreationDate) FROM Posts GROUP BY DAY(CreationDate), MONTH(CreationDate), YEAR(CreationDate) ORDER BY YEAR(CreationDate) DESC, MONTH(CreationDate) DESC, DAY(CreationDate) DESC