Introduction
2. Get to know the tables
UNION
INTERSECT
EXCEPT

Instruction

Okay, let's introduce the tables we'll have as our guests today. Fortunately, there's just two of them this time.

Do you do any sports? If you do, this lecture's going to be right up your alley! We're going to be working with athletes this time and analyzing two tables that contain information about medals that various athletes won in two olympic disciplines. Let's check them out.

Exercise

Display the contents of the Cycling table.

Stuck? Here's a hint!

Type:

SELECT
  *
FROM Cycling;