1. Learn
  2. /
  3. Projects
  4. /
  5. Applying SQL to Real-World Problems

Connected

Exercise

Updated based on other tables

The rental company is running a promotion and needs you to lower the rental costs by 1 dollar of films who star the actors/actresses with the following last names: WILLIS, CHASE, WINSLET, GUINESS, HUDSON.

To UPDATE this data in the film table you will need to identify the film_id for these actors.

Instructions 1/2

undefined XP
    1
    2
  • Write a query to SELECT the film_id for the actors with the following 5 last names WILLIS, CHASE, WINSLET, GUINESS, HUDSON.