0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for people studying math at any level and professionals in related fields

with firstquery as (
Select owneruserid
From Posts B
Where B.Posttypeid = 1 and month(creationdate) = 12  and year(creationdate) = 2016
  And B.Answercount > 0 
  And Datediff(Day,B.Creationdate,(Select Min(Creationdate) From Posts  Where Parentid = B.Id) ) >= 30

)
select * , (select tags from posts where b.parentid = id ) from posts b
where owneruserid in (select distinct owneruserid from firstquery)
and posttypeid = 2 and creationdate >= '2016-12-01'

fork query

edited nov 11

created oct 29 anonymous