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,
  • period – the duration of a loan,
  • date – the date 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.

Console

Code editor

Result

TableConsole