Frequência semestral dos 5 Primeiros anos do GraphQL

0

Please login or register to vote for this query.

(click on this box to dismiss)

Mythology Meta

Q&A about the site for enthusiasts and scholars of mythology and folklore

SELECT * from ( 

        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2015-01-01 00:00:00' and '2015-07-01 23:59:59'
        ) AS 'Quantidade', '2015-01-01 00:00:00 até 2015-07-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2015-07-01 23:59:59' and '2016-01-01 23:59:59'
        ) AS 'Quantidade', '2015-07-01 23:59:59 até 2016-01-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2016-01-01 23:59:59' and '2016-07-01 23:59:59'
        ) AS 'Quantidade', '2016-01-01 23:59:59 até 2016-07-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2016-07-01 23:59:59' and '2017-01-01 23:59:59'
        ) AS 'Quantidade', '2016-07-01 23:59:59 até 2017-01-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2017-01-01 23:59:59' and '2017-07-01 23:59:59'
        ) AS 'Quantidade', '2017-01-01 23:59:59 até 2017-07-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2017-07-01 23:59:59' and '2018-01-01 23:59:59'
        ) AS 'Quantidade', '2017-07-01 23:59:59 até 2018-01-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2018-01-01 23:59:59' and '2018-07-01 23:59:59'
        ) AS 'Quantidade', '2018-01-01 23:59:59 até 2018-07-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2018-07-01 23:59:59' and '2019-01-01 23:59:59'
        ) AS 'Quantidade', '2018-07-01 23:59:59 até 2019-01-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2019-01-01 23:59:59' and '2019-07-01 23:59:59'
        ) AS 'Quantidade', '2019-01-01 23:59:59 até 2019-07-01 23:59:59' AS Faixa
        
UNION ALL
        SELECT(
            Select count(Posts.Id) from Posts
            left join PostTags on PostTags.PostId = Posts.Id
            left join Tags on Tags.Id = PostTags.TagId
            where Tags.TagName = 'graphql'
            and Posts.CreationDate between '2019-07-01 23:59:59' and '2020-01-01 23:59:59'
        ) AS 'Quantidade', '2019-07-01 23:59:59 até 2020-01-01 23:59:59' AS Faixa
        
) TAB 
 order by Quantidade desc

Enter Parameters

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