Simple JOINs recap
3. Get to know the book table
Various kinds of JOINs
Filtering with LEFT JOIN and RIGHT JOIN
Summary

Instruction

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.

Exercise

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!

Type:

SELECT
  *
FROM book

Console

Code editor

Result

TableConsole