DBMS-SQL command CREATE VIEW w/multiple aggregate functions-keep .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Please help - It is for my DB MNGMNT using SQL class - I'm just stumped with
this one: Create a view named OrdTot. It consists of the order number & 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. All info is in the 'OrderLine'
Table.Some order numbers have multiple order lines in the tables - see my
stump! - PLZ HELP - TY!
 
Back
Top