0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT
 t.Id, 
t.ParentId, 
t.PostTypeId,
t.CreationDate, 
t.AnswerCount, 
t.AcceptedAnswerId, 
(select CreationDate from Posts ps where ps.Id = t.AcceptedAnswerId) as AnswerCreationDate,
t.Title, 
t.Body, 
(select Body from Posts a where a.Id = t.AcceptedAnswerId) as AnswerBody,
t.Tags, 
t.Score
FROM Posts t
WHERE ((t.tags like '%<machine-learning>%') 
              and (t.PostTypeId = 1) and (t.Score >1))

fork query

created sep 22 20 anonymous