Untitled

 avatar
unknown
plain_text
2 years ago
216 B
2
Indexable
SELECT c.name,
       COUNT(e.instituition) AS instit
FROM company AS c
LEFT JOIN people AS p ON c.id = p.company_id
LEFT JOIN education AS e ON p.id = e.person_id
GROUP BY c.name
ORDER BY instit DESC
LIMIT 5;
Editor is loading...