Q&A for scientific skepticism
-- Query for comments on questions with Python or JavaScript tags created after February 1, 2024 SELECT c.Id AS CommentId, c.PostId AS PostId, c.Text AS CommentText FROM Comments c JOIN Posts q ON c.PostId = q.Id WHERE (q.Tags LIKE '%python%' OR q.Tags LIKE '%javascript%') AND q.CreationDate >= '2024-01-01' AND q.CreationDate < '2024-02-01' UNION ALL -- Query for comments on answers to questions with Python or JavaScript tags SELECT c.Id AS CommentId, c.PostId AS PostId, c.Text AS CommentText FROM Comments c JOIN Posts a ON c.PostId = a.Id JOIN Posts q ON a.ParentId = q.Id WHERE (q.Tags LIKE '%python%' OR q.Tags LIKE '%javascript%') AND q.CreationDate >= '2024-01-01' AND q.CreationDate < '2024-02-01'