Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select distinct(p.user_id), AGE(u.creation_date, min(p.creation_date) over())
- from stackoverflow.users as u
- join stackoverflow.posts as p on p.user_id = u.id
- where p.creation_date is not null
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement