JOINS - Filtering and Ordering
41.3
Exercise

JOINs with filters - 2

Write a query to display the name of all books which have a next volume, and the next volume is published in the same year as the book itself. Display the name of the book, name of the next volume, publishing year and name of the course original book belongs to, under the headers bookName, nextVolumeName, publishedIn and course.