Save up to $499! Grab all Python courses for $49 or all online courses we’ve ever launched for only $169. Only Feb 11-16. Happy Valentine's!
Dictionary database
7. Dictionary table – exercise 2


Good! You don't have to limit joining a table with itself to just a single join.


Show each dictionary entry (name the column entry) together with the name of its direct hypernym (name the column hypernym) and the name of that hypernym's hypernym (name the column grandhypernym).

Only include words that have both a direct hypernym and a "grandhypernym".

Stuck? Here's a hint!


  entry.word AS entry,
  hypernym.word AS hypernym,
  super_hypernym.word AS grandhypernym
FROM dictionary AS entry
JOIN dictionary AS hypernym
  ON entry.hypernym_id = hypernym.entry_id
JOIN dictionary AS super_hypernym
  ON hypernym.hypernym_id = super_hypernym.entry_id