1. Write a SELECT statement that uses aggregate window functions to calculate the order total for each musician and the order total for each musician by date. Return these columns:

The musician_id column from the orders table

The order_date column from the orders table

The total amount for each order item in the order_instruments table

The sum of the order totals for each musician

The sum of the order totals for each musician by date This query must use the over() clause along with the partition keyword.

Database Schema: ------------------------------ Tables: musicians, orders, order_instruments, instruments Table columns ----------------------- musicians: musician_id, email_address, password, first_name, last_name, shipping_address_id, billing_address_id orders: order_id, musician_id, order_date, ship_amount, tax_amount, ship_date, ship_address_id, card_type, card_number, card_expires, billing_address_id order_instruments: item_id, order_id, instrument_id, item_price, discount_amount, quantity

instruments: instrument_id, category_id, instrument_code, instrument_name, description, list_price, discount_percent, date_added