0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for Data science professionals, Machine Learning specialists, and those interested in learning more about the field

select count(*)
FROM Tags 
JOIN PostTags ON Tags.Id = PostTags.TagId
JOIN Posts ON Posts.Id = PostTags.PostId
JOIN Comments ON Posts.Id = Comments.PostId
WHERE Tags.TagName IN ('python','c++','java','r')
AND (Posts.score != 0 OR Comments.Score != 0)
AND Posts.PostTypeId = 2
AND Posts.CreationDate > DATEADD(Month, -1, DATEADD(dd, DATEDIFF(dd, 0, getdate()), 0) );

fork query

edited jun 22 18

created jun 22 18 anonymous