Q&A for linguists, teachers and students of the Korean language
-- Query for comments on questions with Python or JavaScript tags created after December 1, 2023 SELECT 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 >= '2023-12-01' AND q.CreationDate < '2024-01-01' -- Limit to dates between December 1, 2023, and January 1, 2024 UNION ALL -- Query for comments on answers to questions with Python or JavaScript tags SELECT 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 >= '2023-12-01' AND q.CreationDate < '2024-01-01' -- Limit to dates between December 1, 2023, and January 1, 2024