Advertising income and donations are our only sources of funding to support the project. Please do not disable advertising on the site or make a reasonable donation.
Task 24:
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.
Write your request in the field below and click the "Check it!" button.
To write the answer, use MySQL syntax. Descriptions of the tables are given in the right panel.
Sakila is a sample database developed by MySQL, specifically designed to teach and demonstrate the capabilities of database management systems (DBMS) based on the relational model.
The Sakila database contains 16 main tables describing various aspects of a DVD rental company.
Below is a list of these tables:
Table actor
Table columns:
actor_id - Unique identifier for each actor.
first_name - First name of the actor.
last_name - Last name of the actor.
last_update - When the row was created or most recently updated.
actor_id
first_name
last_name
last_update
1
John
Doe
2023-01-01 12:00:00
Table film
Table columns:
film_id - Unique identifier for each film.
title - The title of the film.
description - A short description or plot summary of the film.
release_year - The year in which the movie was released.
language_id - Foreign key referencing the language table; identifies the language of the film.
original_language_id - A foreign key pointing at the language table; identifies the original language of the film. Used when a film has been dubbed into a new language.
rental_duration - The length of the rental period, in days.
rental_rate - The cost to rent the film for the period specified in the rental_duration column.
length - Duration of the film, in minutes.
replacement_cost - The amount charged to the customer if the film is not returned or is returned in a damaged state.
rating - The rating assigned to the film. Can be one of: G, PG, PG-13, R, or NC-17.
special_features - Lists which common special features are included on the DVD. Can be zero or more of: Trailers, Commentaries, Deleted Scenes, Behind the Scenes.
last_update - When the row was created or most recently updated.
film_id
title
description
release_year
language_id
original_language_id
rental_duration
rental_rate
length
replacement_cost
rating
special_features
last_update
1
Film Title
A brief description of the film.
2000
1
2
5
4.99
120
19.99
PG-13
Trailers, Commentaries
2023-01-01 12:00:00
Table film_text
Table columns:
film_id - Unique identifier for each film.
title - Title of the film.
description - Description of the film.
film_id
title
description
1
Film Title
A brief description of the film.
Table film_actor
Table columns:
actor_id - Unique identifier for actor.
film_id - Unique identifier for film.
last_update - When the row was created or most recently updated.
actor_id
film_id
last_update
1
1
2023-01-01 12:00:00
Table customer
Table columns:
customer_id - Unique identifier for each customer.
store_id - Foreign key referencing the store table.
first_name - First name of the customer.
last_name - Last name of the customer.
email - Email address of the customer.
address_id - Foreign key referencing the address table.
active - Indicates whether the customer is active.
create_date - Timestamp indicating when the customer was added to the database.
last_update - When the row was created or most recently updated.
customer_id
store_id
first_name
last_name
email
address_id
active
create_date
last_update
1
1
John
Doe
john.doe@example.com
1
true
2023-01-01 12:00:00
2023-01-01 12:00:00
Table address
Table columns:
address_id - Unique identifier for each address.
address - Street address.
address2 - Additional address.
district - District or region.
city_id - Foreign key referencing the city table.
postal_code - Postal code.
phone - Phone number.
last_update - When the row was created or most recently updated.
address_id
address
address2
district
city_id
postal_code
phone
last_update
1
123 Main St
[null]
Downtown
1
12345
+1234567890
2023-01-01 12:00:00
Table city
Table columns:
city_id - Unique identifier for each city.
city - City name.
country_id - Foreign key referencing the country table.
last_update - When the row was created or most recently updated.
city_id
city
country_id
last_update
1
Metropolis
1
2023-01-01 12:00:00
Table country
Table columns:
country_id - Unique identifier for each country.
country - Country name.
last_update - When the row was created or most recently updated.
country_id
country
last_update
1
United States
2023-01-01 12:00:00
Table category
Table columns:
category_id - Unique identifier for each category.
name - Name of the category.
last_update - When the row was created or most recently updated.
category_id
name
last_update
1
Action
2023-01-01 12:00:00
Table film_category
Table columns:
film_id - Unique identifier for each film.
category_id - Unique identifier for each category.
last_update - When the row was created or most recently updated.
film_id
category_id
last_update
1
1
2023-01-01 12:00:00
Table language
Table columns:
language_id - Unique identifier for each language.
name - Language name.
last_update - When the row was created or most recently updated.
language_id
name
last_update
1
English
2023-01-01 12:00:00
Table staff
Table columns:
staff_id - Unique identifier for each staff member.
first_name - First name of the staff member.
last_name - Last name of the staff member.
address_id - Foreign key referencing the address table.
picture - Staff member picture.
email - Email address of the staff member.
store_id - Foreign key referencing the store table.
active - Indicates whether the staff member is active.
username - Username for login.
password - Password for login.
last_update - When the row was created or most recently updated.
staff_id
first_name
last_name
address_id
picture
email
store_id
active
username
password
last_update
1
John
Doe
1
[null]
john.doe@example.com
1
true
johndoe
********
2023-01-01 12:00:00
Table staff_list
Table columns:
ID - Unique identifier for each staff list entry.
name - Staff member's name.
address - Staff member's address.
zip code - Staff member's zip code.
phone - Staff member's phone number.
city - Staff member's city.
country - Staff member's country.
SID - Foreign key referencing the staff table.
ID
name
address
zip code
phone
city
country
SID
1
John Doe
123 Main St
12345
+1234567890
Metropolis
United States
1
Table store
Table columns:
store_id - Unique identifier for each store.
manager_staff_id - Foreign key referencing the staff table for the store manager.
address_id - Foreign key referencing the address table.
last_update - When the row was created or most recently updated.
store_id
manager_staff_id
address_id
last_update
1
1
1
2023-01-01 12:00:00
Table payment
Table columns:
payment_id - Unique identifier for each payment.
customer_id - Foreign key referencing the customer table.
staff_id - Foreign key referencing the staff table.
rental_id - Foreign key referencing the rental table.
amount - Payment amount.
payment_date - Date of the payment.
last_update - When the row was created or most recently updated.
payment_id
customer_id
staff_id
rental_id
amount
payment_date
last_update
1
1
1
1
4.99
2023-01-01 12:13:14
2023-01-01 12:14:15
Table inventory
Table columns:
inventory_id - Unique identifier for each inventory item.
film_id - Unique identifier for each film in the inventory.
store_id - Unique identifier for the store where the inventory item is located.
last_update - When the row was created or most recently updated.
inventory_id
film_id
store_id
last_update
1
23
2
2023-01-01 12:00:00
Table rental
Table columns:
rental_id - Unique identifier for each rental.
rental_date - Date when the rental occurred.
inventory_id - Foreign key referencing the inventory table.
customer_id - Foreign key referencing the customer table.
return_date - Date when the rental was returned.
staff_id - Foreign key referencing the staff table.
last_update - When the row was created or most recently updated.