-- Count related entities per parent

SELECT parent_id, COUNT(*) AS related_count
FROM related_entity
WHERE parent_id IN (...)
GROUP BY parent_id;

-- Average value per parent

SELECT parent_id, AVG(score) AS avg_score
FROM ratings
WHERE parent_id IN (...)
GROUP BY parent_id;