Q&A about the site for followers of the Hindu religion and those interested in learning more about Hinduism
WITH tagAndUserStats AS ( SELECT t.tagname, p.owneruserid AS userid, SUM (p.score) AS tagScore, COUNT (p.id) AS postCount FROM posts p INNER JOIN posttags pt ON pt.postid = COALESCE (p.parentid, p.id) INNER JOIN tags t ON t.id = pt.tagid WHERE p.owneruserid >= 1 AND p.posttypeid IN (1, 2) GROUP BY t.tagname, p.owneruserid ) SELECT u.Id AS [User Link], CONCAT('https://serverfault.com/users/', u.Id) AS [Profile Link], u.DisplayName, u.Location, u.WebsiteUrl, u.AboutMe, u.Views, u.UpVotes, u.DownVotes, u.Reputation, ( SELECT TOP 1 tu.tagname FROM tagAndUserStats tu WHERE tu.userid = u.id ORDER BY tu.tagScore DESC ) AS [Top Tag by Score], ( SELECT TOP 1 tu.tagname FROM tagAndUserStats tu WHERE tu.userid = u.id ORDER BY tu.postCount DESC ) AS [Top Tag by Posts] FROM users u WHERE LOWER(Location) LIKE '%stuttgart%'