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'

CREATE an empty new TABLE called oscars.
Store both columns (title and award) as the datatype VARCHAR.

Take Hint (-15 XP)

Exercise

Storing new data

Instructions 1/3