Users with Angular in Atlanta

0

Please login or register to vote for this query.

(click on this box to dismiss)

Android Enthusiasts

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

Enter Parameters

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