Number of New Posts by Post Creation Date for Questions Tagged with "mongodb"

0

Please login or register to vote for this query.

(click on this box to dismiss)

Project Management

Q&A for project managers

SELECT
    CAST(p.CreationDate AS DATE) AS PostDate,
    COUNT(*) AS NumberOfPosts
FROM
    Posts p
    JOIN PostTags pt ON p.Id = pt.PostId
    JOIN Tags t ON pt.TagId = t.Id
WHERE
    t.TagName = 'mongodb'
GROUP BY
    CAST(p.CreationDate AS DATE)
ORDER BY
    PostDate;

Enter Parameters

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