Q&A about the site for expert genealogists and people interested in genealogy or family history
-- Top users by tag and location -- Currently only looking at score for questions. Not sure how to fix this yet. --SELECT TOP 20 * FROM Posts SELECT us.*,tuser.Score, tuser.TagName FROM Users us JOIN (SELECT Answers.OwnerUserId AS UserId, SUM(Answers.Score) AS Score, Tags.TagName FROM Tags JOIN PostTags ON Tags.Id = PostTags.TagId JOIN Posts ON Posts.Id = PostTags.PostId JOIN Posts Answers ON Answers.ParentId = Posts.Id WHERE Tags.TagName IN ('android-jetpack-compose') GROUP BY Answers.OwnerUserId, Tags.TagName ) tuser ON tuser.UserId = us.Id WHERE lower(location) like '%india%' or (lower(location) like '%india%' and lower(location) not like '%india%' ) or (lower(location) like '%india%' and lower(location) not like 'india%on' and lower(location) not like '%india%' and lower(location) not like '%india%' ) or (lower(location) like '%india%' and lower(location) not like '%india%' ) or lower(location) like '%india%' or lower(location) like '%india%' ORDER BY us.Id, tuser.TagName