🙏 We need your help! SQLtest.online has no ads and lives only on donations. Even a small amount helps. Donate now →
SQL code copied to buffer
Task 153:

Delete Film Records

MySQL
From table film, delete records about films that do not exist in the inventory table.
Expected result Columns: 13 · Rows: 0
film_id title description release_year language_id original_language_id rental_duration rental_rate length replacement_cost rating special_features last_update

Write your query below and click "Check it!". Tables are described in the right pane.

Tutorial

By checking a query, you agree that it is stored without your account details and may be included in anonymized datasets, including for AI training. Learn more

The query result will appear here. Ctrl+Enter - Run query