Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
Introduction
3. Get to know the tables – cycling medalists
UNION
INTERSECT
EXCEPT

Instruction

Great, let's find out what we have in there. As you can see, the table contains the following columns:

  • id which is the identification number for each medal.
  • person which is the first and last name of the person who won the medal.
  • country which the person represented.
  • year when the medal was won.
  • place which indicates the kind of medal (1 – gold, 2 – silver, 3 – bronze).

There are, of course, various categories of cycling, but to make things easier, we don't care about them here. We've just picked some sportsmen and sportswomen and put their medals in the table, not too many, so that you can get the hang of the table quickly.

Exercise

Click Next exercise to continue.