0

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 as qid,
       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
  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

fork query

edited oct 28

created oct 28 anonymous