0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people looking to improve their interpersonal communication skills

SELECT
a.Id AS AnswerId, a.CreationDate AS AnswerCreationDate, a.Body AS AnswerBody,
q.Id AS QuestionId, q.CreationDate AS QuestionCreationDate, q.Body AS QuestionBody,
q.title AS QuestionTitle, q.Tags AS Tags
FROM Posts a JOIN Posts q ON
a.ParentId = q.Id AND q.AcceptedAnswerId = a.id WHERE
a.PostTypeId = 2 AND q.Id IN (
SELECT PostId FROM PostTags WHERE TagId = (
            	SELECT Id FROM Tags WHERE TagName = 'kotlin'
            )
)

fork query

edited feb 28

created feb 28 anonymous