Get startedGet started for free

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.

This exercise is part of the course

Applying SQL to Real-World Problems

View Course

Hands-on interactive exercise

Have a go at this exercise by completing this sample code.

SELECT ___ 
FROM ___ AS a
INNER JOIN ___ AS f
   ON a.___ = f.___
WHERE ___ IN ('___', '___', '___', '___', '___');
Edit and Run Code