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

The product$\_$name from the Products 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 order items records in the Order$\_$ltems

table, partioned by product$\_$id$.$ Alias this field as total$\_$by$\_$product

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.