0

Please login or register to vote for this query.

(click on this box to dismiss)

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 > 140 and Posts.ViewCount <= 165

view current version

edited jun 21

created jun 21 user25649593