Q&A for students and teachers of all martial arts
SELECT Posts.Title as Title, Posts.Tags as Tags, Posts.Body as Body, Posts.ViewCount as ViewCount, Posts.CreationDate as CreationDate, Posts.CommentCount as CommentCount, Posts.AnswerCount as AnswerCount, PostTypes. Name AS PostType FROM Posts INNER JOIN PostTags ON PostTags.PostId = Posts. Id INNER JOIN Tags ON Tags.Id = PostTags. TagId INNER JOIN PostTypes ON Posts.PostTypeId = PostTypes.Id WHERE Tags. TagName = 'java' and Posts.ViewCount > 60 and Posts.ViewCount <= 70