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

Business, Finance, Economics, Accounting, Operations Management, Computer Science, Electrical Engineering, Mechanical Engineering, Civil Engineering, Chemical Engineering, Algebra, Precalculus, Statistics and Probabilty, Advanced Math, Physics, Chemistry, Biology, Nursing, Psychology, Certifications, Tests, Prep, and more.
Post Reply
answerhappygod
Site Admin
Posts: 899604
Joined: Mon Aug 02, 2021 8:13 am

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

Post 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 36 times
List the category ID, product ID, product name, and current
product price for the lowest priced product in each category.
Format the price as currency, and use the following column
headings: Cat_ID, Prod_ID, Prod_Name, 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
Join a community of subject matter experts. Register for FREE to view solutions, replies, and use search function. Request answer by replying!
Top
Post Reply

Return to “Archived Questions & Answers”