Q&A about the site for engineers, producers, editors, and enthusiasts spanning the fields of video, and media creation
SELECT Id, PostTypeId, CreationDate, ViewCount, Tags, AnswerCount, FavoriteCount From PostsWithDeleted WHERE PostTypeId = 1 AND YEAR(CreationDate) = 2019;