0

Please login or register to vote for this query.

(click on this box to dismiss)

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%') OR p.tags LIKE('%java%'))
       AND NOT p.tags LIKE('%javascript%')
       AND p.Score >= 15
       AND u.AboutMe <> ''
ORDER BY p.CreationDate DESC

fork query

edited oct 20

created oct 20 4everfun