0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A for professional and enthusiast programmers

SELECT DISTINCT A.Id, A.CreationDate, C.Reputation
FROM Posts AS A
  INNER JOIN PostTypes AS B ON A.PostTypeId = B.Id
  INNER JOIN Users AS C ON A.OwnerUserId = C.Id
  INNER JOIN PostTags AS D ON A.Id = D.PostId
  INNER JOIN Tags AS E ON D.TagId = E.Id
WHERE A.CreationDate > DATEADD(week, DATEDIFF(week, 0, GETDATE())-1, -1)
  AND B.Name = 'Question'  
  AND C.Reputation > 100
  AND E.TagName = 'java'
ORDER BY A.CreationDate DESC;

fork query

created may 15 15 jonrsharpe