🙏 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 107:

Films with Low Rental Time

MySQL
In this task you found the average film rental time (in days). Write a query to receive a list of films that have a below average rental time. Display the result in a table with film_id, title, and average_rental_time columns.
Sort the table by the film_id column.
Expected result Columns: 3 · Rows: 203
film_id title average_rental_time

Sample rows open after wrong checks: 0 of 3

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