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' |
This exercise is part of the course
Applying SQL to Real-World Problems
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Create a new table called oscars
___ (
___ ___,
___ ___
);