1. 学习
    2. /
  2. 项目
    3. /
  3. Applying SQL to Real-World Problems
Connected

练习

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.

说明 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.