Q&A for professional and enthusiast programmers
select distinct Posts.Id, Posts.Title, Posts.Score, Posts.FavoriteCount, Posts.ViewCount, Posts.AnswerCount, Posts.Tags from Posts INNER JOIN PostTags ON PostTags.PostId = Posts.Id INNER JOIN Tags ON Tags.Id = PostTags.TagId INNER JOIN PostTypes ON PostTypes.Id = Posts.PostTypeId left JOIN Users ON Users.Id = Posts.OwnerUserId WHERE Tags.TagName IN ('ibm-cloud-infrastructure') AND Posts.CreationDate BETWEEN '4/01/2019 12:00AM' AND '6/30/2019 12:00AM' Order by Posts.Id Desc