Get startedGet started for free

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

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

-- Create a new table called oscars
___ (
    ___ ___,
    ___ ___
);
Edit and Run Code