Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Simple JOINs recap
3. Get to know the book table
Various kinds of JOINs
Filtering with LEFT JOIN and RIGHT JOIN


The author table wouldn't do us any good without a table to store the names of books they wrote. Take a glance at the book table.


The book table consists of six columns:

  • id – the ID of a given book,
  • author_id – the ID of the author who wrote a given book,
  • title – the title of a given book,
  • publish_year – the year in which a given book was published,
  • publishing_house – the name of the publishing house that printed a given book,
  • rating – the average rating of a given book.

Select all data from the book table.

Stuck? Here's a hint!


FROM book