SELECT p.title, p.user_id, p.score, ROUND(AVG(p.score) OVER(PARTITION BY p.user_id), 0)
FROM stackoverflow.posts p
WHERE p.score > 0
AND p.title != '';