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

JOINs in MS SQL Server

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

Instruction

Sometimes, a book is so popular that it gets adapted to another form (like a movie).

Here comes the Adaptation table!

Exercise

The Adaptation table consists of five columns:

  • BookId – the ID of a given book,
  • Type – the type of adaptation (movie, game, play, musical),
  • Title – the name of a given adaptation,
  • ReleaseYear – the year in which a given adaptation was created,
  • Rating – the average rating of a given adaptation.

Select all data from the Adaptation table.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Adaptation