1. Learn
    2. /
  2. Courses
    3. /
  3. Applying SQL to Real-World Problems

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.