SELECT Count(DISTINCT Users.Id), Tags.TagName as Tag_Name...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Materials Modeling Meta

Q&A for materials modelers and data scientists

SELECT
Count(DISTINCT Users.Id),
Tags.TagName as Tag_Name
FROM
Users, Posts, PostTags, Tags
WHERE
Posts.OwnerUserId = Users.Id AND
PostTags.PostId = Posts.Id AND
Tags.Id = PostTags.TagId AND
Posts.Score > 15 AND
Posts.CreationDate BETWEEN '1/1/2019' AND '10/19/2021' AND Tags.TagName IN ('python', 'r', 'java', 'perl', 'sql', 'c#', 'c ++')
GROUP BY
Tags.TagName

Enter Parameters

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