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' |
Este ejercicio forma parte del curso
Applying SQL to Real-World Problems
Ejercicio interactivo práctico
Prueba este ejercicio completando el código de muestra.
-- Create a new table called oscars
___ (
___ ___,
___ ___
);