Young actors not coming from the USA
As you've just seen, the operators UNION
and INTERSECT
are powerful tools when you work with two or more tables. Identify actors who are not from the USA and actors who were born after 1990.
This exercise is part of the course
Data-Driven Decision Making in SQL
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
SELECT ___, -- Report the name, nationality and the year of birth
___,
___
FROM actors
___; -- Of all actors who are not from the USA