0

Please login or register to vote for this query.

(click on this box to dismiss)

Q&A about the site for music historians, critics, and fans

select
  users.id,
  DATEDIFF(ss, users.creationdate, CURRENT_TIMESTAMP) as AccountAge,
  count(comments.id) as comment_count,
  count(posts.id) as post_count
from users
  left join comments on users.id = comments.userid
  left join posts on users.id = posts.owneruserid
group by users.id, users.creationdate
order by rand()

view current version

edited dec 2

created dec 2 anonymous