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

Instruction

The last table in this set is the museum_loan 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 museum_loan table.

It consists of the following columns:

  • from_museum_id – the ID of the museum that loaned a given piece of art to another museum,
  • to_museum_id – the ID of a museum that received a given piece of art from a given museum,
  • piece_id – 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.