Answer Happy

List the product ID, product name, and product price for the
product(s) sold in more orders than any any other products (based
on number of order occurrences, not the quantity). Format the
price as currency, and use the following column headings:
ProductID, 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