Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close

Wrap course as a gift

Prepare your gift and double-check it looks just right.

Form validation errors

Recipient's Name:
Recipient's Email:
Your Message (Optional):
Proceed to Checkout

PostgreSQL JOINs

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