0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for active researchers, academics and students of physics

(select AllAnswers.UserId , AllAnswers.AnswersBody 
from
(select p.OwnerUserId as UserId,
       p.Body as AnswersBody
from posts p 
where p.PostTypeId = 2
group by p.OwnerUserId, p.Body) as AllAnswers

inner join

(select p1.OwnerUserId
from posts p1
where p1.tags like '%<tensorflow>%'and p1.PostTypeId = 1 and p1.OwnerUserId > 22996
group by p1.OwnerUserId) as TensorflowAnswers



on AllAnswers.UserId = TensorflowAnswers.OwnerUserId)

Union

(select AllAnswers.UserId , AllAnswers.AnswersBody 
from
(select p.OwnerUserId as UserId,
       p.Body as AnswersBody
from posts p 
where p.PostTypeId = 2
group by p.OwnerUserId, p.Body) as AllAnswers

inner join

(select p1.OwnerUserId
from posts p1 inner join Posts p3 on p1.ParentId = p3.Id
where p3.tags like '%<tensorflow>%'and p3.PostTypeId = 1 and p1.PostTypeId = 2
      and p1.OwnerUserId > 22996
group by p1.OwnerUserId) as TensorflowAnswers


on AllAnswers.UserId = TensorflowAnswers.OwnerUserId)



order by AllAnswers.UserId

view current version

edited jul 9 20

created jul 8 20 jon.doe34016