SELECT U.Id AS [User Link], U.Location, T.TagName, SUM(A....

0

Please login or register to vote for this query.

(click on this box to dismiss)

スタック・オーバーフローMeta

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

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 ('%') 
  COLLATE Modern_Spanish_CI_AS
GROUP BY U.Id, U.Location, T.TagName
HAVING T.TagName = ##TagName:string?Azure##
ORDER BY SUM(A.Score) DESC

Enter Parameters

Options:
Switch to main site
loading Hold tight while we fetch your results