How do I solve the following script for SELECT statement that uses aggregate window functions to calculate the order total?

for each customer and the order total for each customer by date. Return these columns:

customer_id: The customer_id column from the Orders table

order_date: The order_date column from the Orders table

item_total: The total amount for each order item in the Order_Items table

customer_total: The sum of the order totals for each customer

customer_total_by_date: The sum of the order totals for each customer by date