Hourly tag questions


Please login or register to vote for this query.

(click on this box to dismiss)

Reverse Engineering Meta

Q&A about the site for researchers and developers who explore the principles of a system through analysis of its structure, function, and operation

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##

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

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

Enter Parameters

Switch to main site
loading Hold tight while we fetch your results