SELECT * from ( SELECT( Select count(Posts.Id) from Post...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Engineering

Q&A for professionals and students of engineering

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 in('rest')
        and Posts.CreationDate between '2015-01-01 00:00:00' and '2020-12-30 23:59:00'
    ) AS 'Quantidade', '2015-2020' AS Faixa

) TAB 
 order by Quantidade desc

Enter Parameters

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