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

GROUP BY Extensions in SQL

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.