sql-final-15

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