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.
Questo esercizio fa parte del corso
Data-Driven Decision Making in SQL
Esercizio pratico interattivo
Prova a risolvere questo esercizio completando il codice di esempio.
SELECT ___, -- Report the name, nationality and the year of birth
___,
___
FROM actors
___; -- Of all actors who are not from the USA