Number of Neo4j questions by month

0

Please login or register to vote for this query.

(click on this box to dismiss)

Ask Ubuntu

Q&A for Ubuntu users and developers

SELECT
    FORMAT(CreationDate, 'yyyy-MM') AS [Month],
    COUNT(*) AS [Number of Python Questions]
FROM
    Posts
WHERE
(Tags LIKE '%<neo4j>%' or Tags LIKE '%<cypher>%')
    AND PostTypeId = 1  -- 1 indicates a question
GROUP BY
    FORMAT(CreationDate, 'yyyy-MM')
ORDER BY
    FORMAT(CreationDate, 'yyyy-MM') ASC;

Enter Parameters

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