1. Uczyć się
    2. /
  2. Projects
    3. /
  3. 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.

Instrukcje 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.