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

Average Weekly Rentals

MySQL
Find the average number of disks rented by each customer in August 2005, broken down by week. 
Present the result in two columns: week_num - week number, weekly_average_rental_count - the average number of discs rented by one user. 
Sort the results by week number.
Expected result Columns: 2 · Rows: 3
week_num weekly_average_rental_count

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