select u.id from posts p left join users u on u.id = p.ow...

0

Please login or register to vote for this query.

(click on this box to dismiss)

Interpersonal Skills

Q&A for people looking to improve their interpersonal communication skills

select u.id
from posts p
left join users u on u.id = p.owneruserid
where u.id != -1
group by u.id
having (case when (max(year(p.creationDate)) - min(year(p.creationDate))) <= 1 then 1 end) > 0

Enter Parameters

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