Tampere C++

0

Please login or register to vote for this query.

(click on this box to dismiss)

History

Q&A for historians and history buffs

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
  UNION
    SELECT OnTopicPosts.Tagname, Comments.UserId AS Id FROM Comments
      INNER JOIN OnTopicPosts ON Comments.PostId = OnTopicPosts.Id
  UNION
    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
  WHERE
    LOWER(Users.Location) LIKE '%finland%'
  GROUP BY ParticipatingUsers.Tagname;

Enter Parameters

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