Write a SELECT statement that uses an aggregate window function to get the total of records in

the Order$\_$Items table. Return these columns:

The product$\_$id column from the Order$\_$ltems table

The total amount for each order item record in the Order$\_$Items table $($Hint: You can calculate the

total amount by subtracting the discount amount from the item price and then multiplying it by

the quantity$).$ Alias this field as order$\_$line$\_$total.

Use an aggregate window function to get a summation of all order items records in the

Order$\_$Items table. Alias this field as total$\_$all$\_$order$\_$lines

Sort the result set in ascending sequence by the product$\_$id column.

Below is a screenshot of records $(12)$ returned by this query. The aggregate window function

highlighted.