SELECT count(cid) FROM comments c GROUP by c.uid
SELECT count(rid) FROM reviews r GROUP by r.uid
SELECT count(nid) FROM node n GROUP by n.uid