Q&A for power users of web applications
SELECT top 20 TagName, SUM(case votes.votetypeid WHEN 2 THEN 1 -- upvote WHEN 3 THEN -1 -- downvote END) as Rep, users.DisplayName as UserName, users.WebsiteUrl, users.Location, users.AboutMe, users.ProfileImageUrl, users.EmailHash, users.AccountId FROM Tags INNER JOIN PostTags ON PostTags.TagId = Tags.id INNER JOIN Posts ON Posts.ParentId = PostTags.PostId INNER JOIN Users ON Posts.OwnerUserId = Users.Id INNER JOIN Votes ON Votes.PostId = Posts.Id WHERE Tags.TagName = 'tensorflow' AND Posts.CommunityOwnedDate IS NULL GROUP BY TagName, DisplayName,WebsiteUrl,Location, AboutMe, ProfileImageUrl, EmailHash, AccountId ORDER BY Rep DESC