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, just two of them this time.

Do you do any sport? Even if not, we're going to deal with sportsmen and sportswomen this time. We're going to analyze two tables which contain information about medals that various people won in two olympic disciplines. Let's check them out.

Exercise

Display the contents of the table cycling.

Stuck? Here's a hint!

Type:

SELECT
  * 
FROM cycling;