CPP and ObjC StackOverflowers

0

Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow

Q&A for professional and enthusiast programmers

SELECT Tags.TagName, COUNT(*) as TagCount
FROM
  Posts
  JOIN PostTags ON Posts.id = PostTags.PostId
  JOIN Tags ON PostTags.TagID = Tags.Id
  WHERE
    Tags.TagName LIKE '%obj%'
GROUP BY Tags.TagName
ORDER BY TagCount DESC;


SELECT TOP 100 Users.DisplayName, Users.Id, Users.Reputation, Users.WebsiteUrl, Users.AboutMe, COUNT(*) as PostCount
FROM
  Users
  JOIN Posts ON Posts.OwnerUserId = Users.Id
  JOIN PostTags ON Posts.id = PostTags.PostId
  JOIN Tags ON PostTags.TagID = Tags.Id
  WHERE
    Tags.TagName LIKE '%c++%'
    AND NOT(
      Users.WebsiteUrl = ''
      AND Users.AboutMe = ''
    )
GROUP BY Users.DisplayName, Users.Id, Users.WebsiteUrl, Users.AboutMe, Users.Reputation
ORDER BY Reputation DESC;

Enter Parameters

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