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


Code editor

TableConsole