I want to know about product sales, by product. I just want to know about produc

Question

I want to know about product sales, by product. I just want to know about products, not who sold them. I need the product number and total sales for the top three items by quantity. dbo.SALES contains columns SPNUM, PRODNUM, & QUANTITY dbo.PRODUCT contains columns PRODNUM, PRODUCTNAME, DESCRIPTION, QOO, QOH, & UNITPRICE Query should join these tables and only list PRODNUM as well as an arithmetic means to multiply UNITPRICE by QUANTITY for the top three highest quantities to view total sales - only PRODNUM and total sales should be viewed.

Explanation / Answer

Create a table in your Mysql database and use the following syntax in your code for accessing the table content............................................. SELECT TABLE1.COLUMN1, TABLE2.COLUMN2... FROM TABLE1, TABLE2 [, TABLE3 ] WHERE TABLE1.COLUMN_NAME = TABLE2.COLUMN_NAME [ AND TABLE1.COLUMN_NAME = TABLE3.COLUMN_NAME ] .........

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.