Q&A for Ubuntu users and developers
--select distinct (select owneruserid from posts where id = comments.postid),creationdate from comments --where postid in --( 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 -- ) --order by postid,creationdate asc ) select * from posts where owneruserid in (select distinct owneruserid from firstquery) and posttypeid = 1 and creationdate >= '2016-12-01'