Users with dotnet experience in mexico

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,
  'https://stackoverflow.com/users/' + CONVERT(nvarchar, Users.ID) + '/' + Users.DisplayName + '?tab=answers' AS StackOverflowProfile,
  COUNT(*) AS DotNetTagCount
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 = '.net'
AND
  Location LIKE '%Mexico%'
GROUP BY
  Users.ID, 
  Users.DisplayName,
  Users.Reputation,
  Users.WebsiteUrl, 
  Users.Location,
  Users.AccountId,
  Users.EmailHash
ORDER BY
  DotNetTagCount DESC

Enter Parameters

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