Delete selected records
You've discovered that some films are just not worth keeping your inventory, for cases where the replacement_cost
is greater than 25 dollars. As such you'd like to remove them from you film
table.
This exercise is part of the course
Applying SQL to Real-World Problems
Exercise instructions
DELETE
records from thefilm
table who have areplacement_cost
that is greater than $25.
Hands-on interactive exercise
Have a go at this exercise by completing this sample code.
-- Delete films that cost most than 25 dollars
___