Question: 4 . [ SQL Week 2 Question 2 0 0 - 5 0 4 ] You want to compute the order total for your shipments.
SQL Week Question You want to compute the order total for your shipments. For all of your shipments, put together a report which contains the following columns.
a Sort it ascending on idShipment
b Create a new field in the output result called OrderTotal, which is the price per unit multiplied by the order quantity. You will need to calculate this field in SQL
c Your output will look a little bit like the following. Your numbers may vary from this example.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
