JOINS - SELF JOIN
39.2
Exercise

SELF JOIN - 1

The table books contains a column nextVolumeId. It stores the id of another book which is the next volume of the book in that row.

Write a query to display the name of all the books which have a next volume, along with the name of the book which is the next volume for each of them.

The headers for the name of books, and the name of the book which is the next volume, should be book and nextVolume respectively.