Write an SQL script that does the following and save this script as CIS$276$DA$\_$FinalExercise$7\_$MEID.sql $.$ Save the output of this script as CIS$276$DA$\_$FinalExercise$7\_$MEID.csv

Use an aggregate window function to display the order id from the Order$\_$Items table along with the total amount for each order item in the Order$\_$Items table. $($HINT: Don't forget the discount!$)$

Also display the total amount for each order

Use an aggregate window function to get the average item amount for each order and display that as a column in the results.

Use a named window for the two aggregate functions.

Sort the results in ascending order by the order$\_$id column