SQL-project-16-23-rewrite

WITH first_and_last AS (
    SELECT company_id
    FROM funding_round
    WHERE is_first_round = 1 AND is_last_round = 1),
ppl AS (
    SELECT people.id,
           company_id
    FROM company
    JOIN people ON company.id = people.company_id
    WHERE status = 'closed'),
edu AS (
    SELECT person_id,
           instituition
    FROM education)
SELECT DISTINCT ppl.id,
       COUNT(DISTINCT edu.instituition)
FROM company
JOIN first_and_last ON company.id = first_and_last.company_id
JOIN ppl ON company.id = ppl.company_id
JOIN edu ON ppl.id = edu.person_id
GROUP BY ppl.id
ORDER BY ppl.id;