Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Get to know the loan table
Summary

Instruction

Well done! Now let's take a look at the table you'll be working with in the exercises. It's named loan and it contains information on loans made by an imaginary bank to imaginary clients.

  • id – the ID of the loan.
  • client_id – the ID of the client.
  • sales_person – the first and last name of the sales person.
  • country – the country where the loan was made.
  • year – the year in which the loan was taken out.
  • quarter – the yearly quarter when the loan was taken out.
  • principal – the amount borrowed.
  • interest – the interest rate on the loan.

Exercise

Select all information from the loan table.