Hourly tag questions

1

Please login or register to vote for this query.

(click on this box to dismiss)

Open Data

Q&A for developers and researchers interested in open data

WITH QuestionsByMonth  AS (
SELECT FLOOR((DATEPART(HOUR, q.CreationDate)*60 + DATEPART(MINUTE, q.CreationDate))/60) AS [Hourly],
          q.Id AS id

    FROM        Posts           q
    INNER JOIN  PostTags        pt
    ON          q.Id            = pt.PostId
    INNER JOIN  Tags            t
    ON          t.Id            = pt.TagId

    WHERE       q.PostTypeId    = 1
    AND         t.TagName       = ##TagName1:string?java##
    AND         t.TagName       != ##TagName2:string?android##
    AND q.CreationDate >= ##PostFrom:string?2020-01-01##

)
SELECT
q.[Hourly], COUNT(q.id) AS Qs

FROM        QuestionsByMonth   q
GROUP BY    q.[Hourly]
ORDER BY    q.[Hourly]

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results