0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for members of the workforce navigating the professional setting

SELECT DISTINCT Posts.Title AS Title,
                CONCAT('https://ai.stackexchange.com/questions', '/', Posts.Id) AS Link,
                Posts.CreationDate AS Created,
                Posts.ViewCount AS Views,
                Posts.Tags AS Tags,
                Posts.AcceptedAnswerId,
                Posts.Score,
                Posts.AnswerCount,
                Posts.ClosedDate
FROM   Posts
       INNER JOIN PostTags ON PostTags.PostId = Posts.Id
       INNER JOIN Tags ON Tags.Id = PostTags.TagId
WHERE  Posts.CreationDate IS NOT NULL
       AND Posts.PostTypeId = 1 -- include only question types
       AND Posts.Score >= 1
       AND (YEAR(Posts.CreationDate) = YEAR(GETDATE()) 
  OR (Posts.ViewCount / ( YEAR(GETDATE())- YEAR(Posts.CreationDate)) >= 3000 ))
ORDER  BY Posts.ViewCount DESC,
          Posts.CreationDate DESC

fork query

edited oct 3

created jul 13 anonymous