Q&A for enthusiasts and power users of the Android operating system
SELECT DISTINCT Users.ID, Users.DisplayName, Users.Reputation, Users.WebsiteUrl, Users.Location, 'https://stackoverflow.com/users/' + CONVERT(nvarchar, Users.ID) + '/' + Users.DisplayName + '?tab=answers' AS StackOverflowProfile, COUNT(*) AS AngularTagCount FROM Users INNER JOIN Comments ON Comments.UserId = Users.ID INNER JOIN Posts On Posts.ID = Comments.PostId INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON PostTags.TagId = Tags.Id WHERE TagName = 'angularjs' AND (Location LIKE '%Atlanta%' OR Location LIKE '%Alpharetta%' OR Location LIKE '%Norcross%' OR Location LIKE '%Duluth%' OR Location LIKE '%Peachtree Corners%') AND Location LIKE '%GA%' GROUP BY Users.ID, Users.DisplayName, Users.Reputation, Users.WebsiteUrl, Users.Location, Users.AccountId, Users.EmailHash ORDER BY AngularTagCount DESC