SELECT Posts.Id,Posts.Title,LEN(Posts.title) as title_len...


Please login or register to vote for this query.

(click on this box to dismiss)


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 title_len,Posts.Body,LEN(Posts.Body) as body_len, Posts.AnswerCount,Posts.CommentCount,Posts.FavoriteCount, Users.Id,Users.DisplayName,Users.Reputation,Users.UpVotes, Users.DownVotes, 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>%'

Enter Parameters

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