Users with dotnet in Atlanta

0

Please login or register to vote for this query.

(click on this box to dismiss)

Raspberry Pi

Q&A for users and developers of hardware and software for Raspberry Pi

SELECT DISTINCT
  Users.ID, 
  Users.DisplayName, 
  Users.Reputation,
  Users.WebsiteUrl, 
  Users.Location,
  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 Like '%azure%'
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
ORDER BY
  AngularTagCount DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results