Only this week, get the SQL Complete Track of 9 courses in a special prize of $330 $89!
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