Q&A about the site for cartographers, geographers and GIS professionals
SELECT Id, Title, PostTypeId, CreationDate, Score, Viewcount, Tags, AnswerCount, FavoriteCount FROM Posts WHERE PostTypeId = 1 and CreationDate >= '2019-01-01' and CreationDate < '2020-01-01'