- SELECT name,
- count(DISTINCT e.instituition) as univ_qty
- FROM people as p
- JOIN education AS e ON p.id=e.person_id
- JOIN company AS c ON c.id=p.id
- GROUP by name
- ORDER BY univ_qty DESC
- LIMIT 5
Untitled
From Alex, 4 Months ago, written in Plain Text, viewed 47 times.
This paste will join the choir invisible in 1 Second.
URL http://codebin.org/view/b4043783
Embed
Download Paste or View Raw
— Expand Paste to full width of browser