Session Ready
Exercise

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'
Instructions 1/3
undefined XP
  • 1
  • 2
  • 3
  • CREATE an empty new TABLE called oscars.
  • Store both columns (title and award) as the datatype VARCHAR.