Save up to $499! Grab all Python courses for$49 or all online courses we’ve ever launched for only \$169. Only Feb 11-16. Happy Valentine's!
Introduction
UNION
INTERSECT
EXCEPT

## Instruction

Nice! Remember how we explained EXCEPT and we said that it returns the rows from the first table MINUS the rows from the second table? The choice of words was no coincidence: some databases use the keyword MINUS instead of EXCEPT.

You should therefore always check your database documentation before writing such queries.

There are also some databases which support both words, just like our database - so why not try an exercise?

## Exercise

Find all the years when there was at least one medal in skating but no medals in cycling. Use the keyword MINUS.

### Stuck? Here's a hint!

Type:

SELECT
year
FROM skating
MINUS
SELECT
year
FROM cycling;