AIHelperBot
Loading...
Open main menu
SQL Generator
Pricing
Posts
Snippet
average film rentals per month
Copy
SELECT
EXTRACT
(
MONTH
FROM
rental_date )
AS
month
,
COUNT
(
*
)
/
COUNT
(
DISTINCT
EXTRACT
(
YEAR
FROM
rental_date ) )
AS
avg_rentals_per_month
FROM
rental
GROUP
BY
month
;
dvdrental
public