Create a view named OrdTot. It consists of the order number and order total for each order currently on file. (The order total is the sum of the number ordered multiplied by the quoted price on each...

Create a view named OrdTot. It consists of the order number and order total for each order currently on file.

(The order total is the sum of the number ordered multiplied by the quoted price on each order line for each

order.) Display the data in the view.