4 CREATE VIEW user_view AS
19 p.creator_id = u.id) AS number_of_posts,
22 coalesce(sum(score), 0)
28 AND p.id = pl.post_id) AS post_score,
35 c.creator_id = u.id) AS number_of_comments,
38 coalesce(sum(score), 0)
44 AND c.id = cl.comment_id) AS comment_score