Q&A for people looking to improve their interpersonal communication skills
select u.id from posts p join users u on u.id = p.owneruserid where (year(p.creationDate) - year(p.creationDate)) <= 1