SQL – Microsoft Access
——————————————————————————
For every product that has been ordered, display the product IDand the total quantity ordered (label this result TotalOrdered).Sort the most popular product first and the least popular last.
——————————————————————————
Product_T ProductID ▽| ProductDescription ▽| ProductFinish ▽| ProductStandardPrice ▽| ProductLineID ▽ $175.00 $200.00 $375.00 $650.00 $325.00 $750.00 $800.00 $250.00 $0.00 1 End Table 2 Coffee Table 3 Computer Desk 4 Entertainment Center 5 Writers Desk 6 8-Drawer Desk 7 Dining Table 8 Computer Desk Cherry Natural Ash Natural Ash Natural Maple Cherry
OR
OR