Advertisement
Incrementator

Untitled

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