+--------------------------------------------------------+ | SAKILA CORE SCHEMA | +--------------------------------------------------------+ | [Customer] <---> [Rental] <---> [Inventory] <---> [Film] | | | | | [Payment] [Actor] | +--------------------------------------------------------+
SELECT payment_date, amount, SUM(amount) OVER (ORDER BY payment_date) AS cumulative_revenue FROM ( SELECT CAST(payment_date AS DATE) AS payment_date, SUM(amount) AS amount FROM payment GROUP BY CAST(payment_date AS DATE) ) p ORDER BY payment_date; sakila hot sences target full