Untitled
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...