Tampere C++


Please login or register to vote for this query.

(click on this box to dismiss)

Stack Overflow Meta en español

Preguntas y respuestas sobre el sitio para programadores y profesionales de la informática

WITH OnTopicPosts AS (
  SELECT Posts.Id, Posts.OwnerUserId, Tags.Tagname FROM Posts
    INNER JOIN PostTags ON PostTags.PostId = Posts.Id
    INNER JOIN Tags ON Tags.Id = PostTags.TagId
    WHERE Tags.Tagname IN ('signal-processing', 'image-processing')

ParticipatingUsers AS (
    SELECT OnTopicPosts.Tagname, OnTopicPosts.OwnerUserId AS Id FROM OnTopicPosts
    SELECT OnTopicPosts.Tagname, Comments.UserId AS Id FROM Comments
      INNER JOIN OnTopicPosts ON Comments.PostId = OnTopicPosts.Id
    SELECT OnTopicPosts.Tagname, Votes.UserId AS Id FROM Votes
      INNER JOIN OnTopicPosts ON Votes.PostId = OnTopicPosts.Id

SELECT ParticipatingUsers.Tagname, COUNT(ParticipatingUsers.Id) FROM ParticipatingUsers
  INNER JOIN Users ON ParticipatingUsers.Id = Users.Id
    LOWER(Users.Location) LIKE '%finland%'
  GROUP BY ParticipatingUsers.Tagname;

Enter Parameters

Switch sites:
loading Hold tight while we fetch your results