Untitled
unknown
sql
2 years ago
357 B
4
Indexable
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
Editor is loading...