Untitled

SELECT 
p.id,
COUNT(e.instituition)
FROM company AS c
INNER JOIN people AS p ON c.id=p.company_id
INNER JOIN education AS e ON p.id=e.person_id
WHERE c.status = 'closed' AND c.id IN (SELECT id
                                          FROM funding_round
                                          WHERE is_first_round = 1 AND is_last_round = 1)
GROUP BY p.id