SELECT P.Id AS PostId, P.PostTypeId, P.OwnerUserId AS Use...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Writing

Q&A for the craft of professional writing, including fiction, non-fiction, technical, scholarly, and commercial writing

SELECT 
    P.Id AS PostId,
    P.PostTypeId,
    P.OwnerUserId AS UserId,
    U.Reputation,
    U.CreationDate AS UserCreationDate,
    U.DisplayName AS Username,
    P.Title AS PostTitle,
    P.Body AS PostBody,
    P.Tags AS PostTags,
    P.Score AS PostScore,
    P.ViewCount,
    P.AnswerCount,
    P.CommentCount,
    P.CreationDate AS PostCreationDate,
    P.LastActivityDate AS LastActivityDate,
    P.AcceptedAnswerId
FROM 
    Posts AS P
JOIN 
    Users AS U ON P.OwnerUserId = U.Id
WHERE 
    P.PostTypeId = 1 -- 1 for questions
    AND P.CreationDate >= '2018-01-01' -- Consider posts created after January 1, 2020
    AND P.CreationDate < '2020-01-01' -- Consider posts created before January 1, 2021
    AND U.Reputation >= 20000 -- Filter users with reputation score of 10,000 or higher
    AND P.Tags IS NOT NULL -- Ensure that the post has tags
ORDER BY 
    P.CreationDate DESC; -- You can change the order as per your preference

Enter Parameters

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