postgresql-count

0

Please login or register to vote for this query.

(click on this box to dismiss)

Bicycles

Q&A for people who build and repair bicycles, people who train cycling, or commute on bicycles

SELECT
    CAST(DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS DATE) AS Month,
    COUNT(*) AS QuestionCount
FROM
    Posts
WHERE
    Tags LIKE '%<sql server>%'
    AND PostTypeId = 1
GROUP BY
    CAST(DATEADD(month, DATEDIFF(month, 0, CreationDate), 0) AS DATE)
ORDER BY
    Month;

Enter Parameters

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