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

In this section, we'll work with four tables. You've encountered three of them before, so this will serve as a quick refresher.

  • Artist,
  • Museum,
  • PieceOfArt,
  • MuseumLoan.

Let's get started with the Artist table.

Exercise

Select all data from the Artist table. It consists of the following columns:

  • Id – the ID of a given artist,
  • Name – the name of a given artist,
  • BirthYear – the year of birth of a given artist,
  • DeathYear – the year of death of a given artist,
  • ArtisticField – the field of art that a given artist focused on,
  • CountryOrigin – the name of the country in which a given artist was born.