Storing new data
You're planing to run a promotion on movies that won a best film academy award in the last 5 years. To do this you need to add a table in your database containing the movies which won an Oscar for best film.
The data you need for this exercise is provided in the table below:
| title | award |
|---|---|
| 'TRANSLATION SUMMER' | 'Best Film' |
| 'DORADO NOTTING' | 'Best Film' |
| 'MARS ROMAN' | 'Best Film' |
| 'CUPBOARD SINNERS' | 'Best Film' |
| 'LONELY ELEPHANT' | 'Best Film' |
Den här övningen är en del av kursen
Applying SQL to Real-World Problems
Interaktiv övning med praktiskt arbete
Testa den här övningen genom att slutföra den här exempelkoden.
-- Create a new table called oscars
___ (
___ ___,
___ ___
);