SELECT DISTINCT p.Title, p.Tags, u.Reputation, p.Score, C...

0

Please login or register to vote for this query.

(click on this box to dismiss)

The Workplace Meta

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

SELECT DISTINCT p.Title, p.Tags, u.Reputation, p.Score, 
CONCAT('http://stackoverflow.com/question/', p.Id) AS URL,
p.AnswerCount, p.AcceptedAnswerId, p.CommentCount, p.CreationDate
FROM Posts p
JOIN Users u
ON p.OwnerUserId = u.Id
WHERE u.Reputation > 1000
AND p.CreationDate > '09/15/2019'
AND p.Tags LIKE '%c#%'
ORDER BY p.CreationDate DESC,
         u.Reputation DESC

Enter Parameters

Options:
Switch sites:
loading Hold tight while we fetch your results