Q&A for speakers of other languages learning English
-- Enter Query Title -- Enter Query Description --SELECT count(convert(DATETIME, convert(VARCHAR, CreationDate, 111))), convert(DATETIME, convert(VARCHAR, CreationDate, 111)) from posts group by convert(DATETIME, convert(VARCHAR, CreationDate, 111)) order by convert(DATETIME, convert(VARCHAR, CreationDate, 111)) desc select count(id) from Posts