Need Help With SQL code Find how many units of each product have been ordered. T

Question

Need Help With SQL code

Find how many units of each product have been ordered.

The Answer Is the table Below

product_description

Expr1001

8-Drawer Dresser

2

Coffee Table

4

Computer Desk

26

Dining Table

5

End Table

5

Entertainment Center

8

Writer's Desk

2

product_description

Expr1001

8-Drawer Dresser

2

Coffee Table

4

Computer Desk

26

Dining Table

5

End Table

5

Entertainment Center

8

Writer's Desk

2

Tables Customert Customer-t Orderlinet Order-t Customer-1 customer-address City-| Galnesville FL Customer name State -Postal-code. Clck to Add . Contemporary Casuals 1355 5. Hines Blvd. 15145 S.W. 17th St. - - 2 Value Furniture Order IDProduct ID 1001 Carteret QuantityCick to Add Sacrameo CA 6 Fumiture Gallery325 Flatiron D 7 Period Furniture 8 California Classics 9 M& H Casual Furniture 3709 First Street 7954 1001 Santa Clara CA Clearwater FL 10 Seminole Interiors 2400 Rocky Point Dr. Seminole FL 11 American Euro Lifestyle 2424 Missouri Ave.N. Prospect Park N Order t Order ID Customer ID Click to Add 1001 1002 1003 1004 1005 1006 -1007 1008 1009 1010 1007 10/24/2004 1009 10/30/2004 11/5/2004 11/5/2005 Product t Product ID ·| Product Description Product-Fin-1 Standard-Price Product Line-ld , | Click to Add w 1 End Table 2 Coffee Table $175.00 10001 $200.00 20001 $375.00 20001 Natural Ash Entertainment Center 5 Writer's Desk 6 8-Drawer Dresser Natural Maple White Ash Walnut Walnut $325.00 10001 $T50.00 20001 800.00 $250.00 30001 8 Computer Desk 0.00 $0.00 New)

Explanation / Answer

select pr.Product_Desc, sum ( ol.quantity ) EXPR1001 from product_t pr, Order_line_t ol

WHERE pr.Product_ID= ol.Product_ID GROUP BY pr.Product_Desc

please change your alias and column name based on your needs

Related Questions

Navigate

• Browse (All)
• Browse N
• Subjects

---

---

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