SELECT COUNT(*) FROM Posts p WHERE p.Id IN (SELECT pt.Pos...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT COUNT(*) FROM Posts p
WHERE p.Id IN 
  (SELECT pt.PostId FROM PostTags pt WHERE pt.TagId IN 
    (SELECT t.Id FROM Tags t WHERE TagName IN ('c#', 'java', 'javascript')))
AND p.CreationDate > DATEADD(month, -1, GETUTCDATE())

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results