select u.id, max(p.creationDate) y1, min(p.creationDate) ...

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, max(p.creationDate) y1, min(p.creationDate)
from posts p
left join users u on u.id = p.owneruserid
where u.id != -1
group by u.id

Enter Parameters

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