Is there a neat way to build a user posts/likes/comments query?
SELECT u.id,
       u.name,
       COALESCE(p.cnt, 0) posts, 
       COALESCE(c.cnt, 0) comments, 
       COALESCE(l.cnt, 0) likes
FROM users u
LEFT JOIN ( SELECT user_id, COUNT(*) cnt
            FROM posts 
            GROUP BY user_id ) p ON  u.id = p.user_id
LEFT JOIN ( SELECT user_id, COUNT(*) cnt
            FROM comments
            GROUP BY user_id ) c ON  u.id = c.user_id
LEFT JOIN ( SELECT user_id, COUNT(*) cnt
            FROM likes
            GROUP BY user_id ) l ON  u.id = l.user_id