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;