0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for scientists using computers to solve scientific problems

SELECT
    P.Id AS [Post ID],
    P.Title AS [Question Title],
    P.Body AS [Question Body],
    T.TagName AS [Tag]
FROM
    Posts AS P
JOIN
    PostTags AS PT ON P.Id = PT.PostId
JOIN
    Tags AS T ON PT.TagId = T.Id
WHERE
    P.PostTypeId = 1 -- Selects only questions (PostTypeId 1)
    AND T.TagName LIKE '%computer-science%' -- Modify as needed to include relevant computer science tags
ORDER BY
    P.Id DESC; -- You can change the sorting order as needed

fork query

created sep 30 anonymous