Deals Of The Week - hours only!Up to 80% off on all courses and bundles.-Close
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 play 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 cycling table.

Stuck? Here's a hint!

Type:

SELECT *
FROM cycling;