Question: 1 1 or more products 2 0 0 8 0 Write an SQL query to find all products for which the total quantity sold is
or more products
Write an SQL query to find all products for which the total quantity sold is more than Your query should return the product names and the total quantity sold for these products.
order them in the decreasing order of the total quantity sold.
Tables Schema as Below.
tabletableProductscolumnNamedataTypeProductIDinttableProductNamevarcharProductSalescolumnNamedataTypeSaleIDintProductIDinttableQuantitySoldintSaleDatedate
Output
ProductNameTotalQuantitySold
SmartPhonel
HeadPhones
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
