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

[answerhappygod]

Product 1 Prodid Prodname Prodcatid Prodprice Orderdetail 1 Orderid 1 Prodid Prodqty Prodprice Order 9 Orderid Orderdate 1 (45.25 KiB) Viewed 34 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