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