Q&A for those interested in the geology, meteorology, oceanography, and environmental sciences
SELECT TOP 50000 Title, Body, Tags, Id, Score, ViewCount, AnswerCount, CreationDate FROM Posts WHERE PostTypeId = 1 AND ViewCount IS NOT NULL AND LEN(Tags) - LEN(REPLACE(Tags, '<', '')) >= 2 AND CreationDate >= '2023-01-01' -- Filtrer les questions récentes ORDER BY ViewCount DESC, Score DESC