Q&A for science fiction and fantasy enthusiasts
SELECT FORMAT(CreationDate, 'yyyy') AS [Year], COUNT(*) AS [Number of Neo4j Questions] FROM Posts WHERE (Tags LIKE '%<neo4j>%' or Tags LIKE '%<cypher>%') AND PostTypeId = 1 -- 1 indicates a question GROUP BY FORMAT(CreationDate, 'yyyy') ORDER BY FORMAT(CreationDate, 'yyyy') ASC;