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

Average Rental Duration

MySQL
Determine the average rental duration (in days) for films. Present the result in a column named average_rental_time.
The rental time is calculated as the difference between return_date and rental_date in the rental table.
Round the result to the nearest whole number.
Expected result Columns: 1 · Rows: 1
average_rental_time

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