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

SQL Practice Set in MS SQL Server

Introduction
Challenge with artists

Instruction

The last table in this set is the MuseumLoan table. This contains information about pieces of art rented by or loaned to another museum. Note that all the data in this table are made up.

Exercise

Select all data from the MuseumLoan table.

It consists of the following columns:

  • FromMuseumId – the ID of the museum that loaned a given piece of art to another museum,
  • ToMuseumId – the ID of a museum that received a given piece of art from a given museum,
  • PieceId – the ID of a given piece of art that was loaned,
  • Period – the duration of a loan,
  • Year – the year when the loan started,
  • Exchange – a boolean column that indicates whether a given loan was a part of an exchange for another piece of art or not.