0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for operations research and analytics professionals, educators, and students

SELECT q.Score, COUNT(*)
FROM Posts q 
LEFT JOIN USERS w ON q.OwnerUserId = w.id 
WHERE q.PostTypeId = 1 
AND DATEDIFF(hour, w.CreationDate, w.LastAccessDate) > 100
GROUP BY q.Score
ORDER BY q.Score

fork query

edited aug 31

created apr 28 19 anonymous