server/migrations/2019-04-08-015947_create_user_view/up.sql

   1 create view user_view as
   2 select id,
   3 name,
   4 fedi_name,
   5 admin,
   6 banned,
   7 published,
   8 (select count(*) from post p where p.creator_id = u.id) as number_of_posts,
   9 (select coalesce(sum(score), 0) from post p, post_like pl where u.id = p.creator_id and p.id = pl.post_id) as post_score,
  10 (select count(*) from comment c where c.creator_id = u.id) as number_of_comments,
  11 (select coalesce(sum(score), 0) from comment c, comment_like cl where u.id = c.creator_id and c.id = cl.comment_id) as comment_score
  12 from user_ u;