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 Cycling table contains the following columns:

  • Id is the identification number for each cycling medal.
  • Person is the first and last name of the athlete who won the medal.
  • Country denotes the country that the athlete represents.
  • Year is when the medal was won by the athlete.
  • Place indicates the kind of medal the athlete received (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 athletes and put their medals in the table.

Exercise

Click Next exercise to continue.