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

11 or more products
20080
Write an SQL query to find all products for which the total quantity sold is more than 11. 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.
\table[[\table[[Products]]],[columnName,dataType],[ProductID,int],[\table[[ProductName]],varchar(255)],[ProductSales],[columnName,dataType],[SaleID,int],[ProductID,int],[\table[[QuantitySold]],int],[SaleDate,date]]
Output
ProductName|TotalQuantitySold
SmartPhonel 15
HeadPhones 112
 11 or more products 20080 Write an SQL query to find

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!