top reputation

0

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

DECLARE @UserId int = 953553;

--Select top 15 * from Users order by reputation desc;
SELECT @UserId, '{'+ STUFF((SELECT CONCAT('"', TagName COLLATE DATABASE_DEFAULT,'": ', count (*),' ,')
			  FROM Tags
              INNER JOIN PostTags ON PostTags.TagId = Tags.id
              INNER JOIN Posts ON Posts.ParentId = PostTags.PostId
              WHERE Posts.OwnerUserId = @UserId
			  GROUP BY TagName
              order by count(*) desc
			  FOR XML PATH('')), 0, 1, '') AS [Output]

Enter Parameters

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