Relevant Python and Java posts in 2020 with information about author

0

Please login or register to vote for this query.

(click on this box to dismiss)

Computer Science Educators

Q&A for those involved in the field of teaching Computer Science

SELECT p.Title, p.Body, p.CreationDate, p.Id as [Post Link], p.Tags, p.Score, u.AboutMe 
FROM POSTS as p
LEFT JOIN Users as u
ON p.OwnerUserId=u.Id
WHERE p.PostTypeId IN(1)
       AND p.CreationDate > '2020-01-01'
       AND p.CreationDate < '2020-12-31'
       AND p.tags LIKE('%python%')
       AND p.Score >= 15
       AND u.AboutMe <> ''
ORDER BY p.CreationDate DESC

Enter Parameters

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