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 top 5 U.Id , '{'+ Replace(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 = U.Id 
			  GROUP BY TagName
              order by count(*) desc
              FOR XML PATH('')), 1, 0, '')+'%',',%','')+'}' AS [Output]
       from Users U
        where location like '%Warsaw%'
       group by U.Id ;

Enter Parameters

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