Q&A for scientists using computers to solve scientific problems
SELECT TOP 1000 Tags, (LEN(Tags) - LEN(REPLACE(Tags, ',', ''))) + 1 AS NumberOfTags, Id AS PostId, OwnerUserId AS UserId, LEFT(Body, 300) AS PostBody FROM Posts WHERE Tags IS NOT NULL AND (LEN(Tags) - LEN(REPLACE(Tags, ',', ''))) + 1 >= 5 AND CreationDate >= '2024-10-01' ORDER BY NumberOfTags DESC;