Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT Id, CreationDate, Body, Title FROM Posts WHERE PostTypeId = 1 -- 1 indicates a Question post AND YEAR(CreationDate) = 2024 ORDER BY CreationDate DESC