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 PostgreSQL

Introduction
2. Get to know the cat table
Exercises

Instruction

Okay! Time for a little warm up. The next few exercises focus on the very basics of the basics. We have a perfect table just for that…

Exercise

The cat table! Select all data from this table. As you can see, the table has the following columns (their names are mostly self-explanatory):

  • id – the ID of a given cat.
  • name – the name of a given cat.
  • breed – the breed of a given cat.
  • coloration – the coloration of a given cat.
  • age – the age of a given cat.
  • sex – the sex of a given cat.
  • fav_toy – the most favorite toy of a given cat.

All set? Let's get started!