This Is based on Murach's MySQL 3rd edition with the my_guitar_shop databases

I need help writing the SQL queries

1. Write a 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:

The customer_id column from the Orders table

The order_date column from the Orders table

The total amount for each order item in the Order_Items table

The sum of the order totals for each customer

The sum of the order totals for each customer by date (Hint: You can create a peer group to get these values)