1 CREATE VIEW user_view AS
15 p.creator_id = u.id) AS number_of_posts,
18 coalesce(sum(score), 0)
24 AND p.id = pl.post_id) AS post_score,
31 c.creator_id = u.id) AS number_of_comments,
34 coalesce(sum(score), 0)
40 AND c.id = cl.comment_id) AS comment_score