0

Please login or register to vote for this query.

(click on this box to dismiss)

プログラマーと熱狂的なプログラマーのためのサイトに関する質問と回答

SELECT U.Id AS [User Link], U.Location, T.TagName, SUM(A.Score) AS TagScore
FROM Users U
  INNER JOIN Posts A ON A.OwnerUserId = U.Id AND A.PostTypeId = 2
  INNER JOIN Posts Q ON Q.Id = A.ParentId AND Q.PostTypeId = 1
  INNER JOIN PostTags PT ON PT.PostId = Q.Id
  INNER JOIN Tags T ON T.Id = PT.TagId
WHERE U.Location LIKE ('%' + ##Location:string?Arkansas## + '%') 
  COLLATE Modern_Spanish_CI_AS
GROUP BY U.Id, U.Location, T.TagName
HAVING T.TagName = ##TagName:string?java##
ORDER BY SUM(A.Score) DESC

fork query

edited mar 2

created mar 2 anonymous