0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for information security professionals

SELECT 
    p.Id AS [PostId],
    p.PostTypeId, -- 1 for Questions, 2 for Answers
    p.CreationDate,
    p.Score,
    p.Body
FROM 
    Posts p
LEFT JOIN 
    Posts q ON p.ParentId = q.Id
WHERE 
    YEAR(p.CreationDate) = 2024 -- Filter by year
    AND MONTH(p.CreationDate) IN (6,7,8)
    AND (
        (p.PostTypeId = 1 AND p.Tags LIKE '%<java>%') -- Java questions
        OR (p.PostTypeId = 2 AND q.Tags LIKE '%<java>%') -- Java answers
    )
ORDER BY 
    p.CreationDate DESC;

fork query

edited nov 16

created nov 16 jon.doe46226