Q&A for those committed to a vegan or vegetarian lifestyle and anyone interested in learning more
SELECT Posts.Id as qid,
Posts.PostTypeId as ptid,
LEN (Posts.title) AS qtl,
LEN (Posts.Body) AS qbl,
Posts.CommentCount as qcc,
Posts.FavoriteCount as qfc,
Users.Id as uid,
Users.Reputation as ur,
Posts.AnswerCount as qac,
Posts.Score as qsm,
DATEDIFF(second, '1970-01-01 00:00:00', Posts.CreationDate) as qt,
Posts.Tags as tags
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