Page 1 of 1

PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate

Posted: Mon May 02, 2022 12:47 pm
by answerhappygod
Product 1 Prodid Prodname Prodcatid Prodprice Orderdetail 1 Orderid 1 Prodid Prodqty Prodprice Order 9 Orderid Orderdate 1
Product 1 Prodid Prodname Prodcatid Prodprice Orderdetail 1 Orderid 1 Prodid Prodqty Prodprice Order 9 Orderid Orderdate 1 (45.25 KiB) Viewed 27 times
List the product ID, product name, category name, and price for
the highest priced product(s) sold in order 100. Show the
price formatted as currency, and use the following column
headings: Product_ID, Product_Name, Category, Price.
PRODUCT 1 ProdID ProdName ProdCatID ProdPrice ORDERDETAIL 1 OrderID 1 ProdID ProdQty ProdPrice ORDER 9 OrderID OrderDate CustID CUSTOMER CustID CustName Custl Name CustPhone SalesRepID PRODCAT 1 ProdCatID ProdCatName COMMISSION 1 CommClass CommRate SALESREP SalesRepID SalesRepFName SalesRepl.Name CommClass Deptid al DEPARTMENT Deptid DeptName