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.
Bu egzersiz
Applying SQL to Real-World Problems
kursunun bir parçasıdırUygulamalı interaktif egzersiz
Bu örnek kodu tamamlayarak bu egzersizi bitirin.
SELECT ___
FROM ___ AS a
INNER JOIN ___ AS f
ON a.___ = f.___
WHERE ___ IN ('___', '___', '___', '___', '___');