0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for power users of web applications

SELECT
    Id AS AnswerId,
    CreationDate,
    Body,
    Score,
    ParentId AS QuestionId
FROM
    Posts
WHERE
    PostTypeId = 2 -- Filters for answers
    AND ParentId IN (
        SELECT Id
        FROM Posts
        WHERE Tags LIKE '%<java>%'
        AND PostTypeId = 1 -- Filters for questions
        AND YEAR(CreationDate) = 2024
    )
ORDER BY
    CreationDate DESC

fork query

edited nov 9

created nov 9 anonymous