SELECT Posts.Id, Posts.Title, LEN (Posts.title) AS TitleL...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Vegetarianism

Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more

SELECT Posts.Id,
       Posts.Title,
       LEN (Posts.title) AS TitleLength,
       Posts.Body,
       LEN (Posts.Body) AS BodyLength,
       Posts.CommentCount,
       Posts.FavoriteCount,
       Users.Id,
       Users.DisplayName,
       Users.Reputation,
       Posts.AnswerCount,
       Posts.Score
  FROM Posts, PostTypes, Users
 WHERE     Posts.PostTypeId = PostTypes.Id
       AND Posts.OwnerUserId = Users.Id
       AND PostTypes.Name = 'Question'
       AND Posts.CreationDate > '2020-01-01'
       AND Posts.CreationDate < '2020-12-31'
       AND Posts.ClosedDate IS NULL
       AND Posts.Tags LIKE '%<sql>%'
       AND Posts.Tags LIKE '%<oracle>%'
ORDER BY Posts.Id

Enter Parameters

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