Question

Consider the table ORDERS as given below:

O_ID	C_Name	Product	Quantity	Price
1001	Jitendra	Laptop	1	12,000
1002	Mustafa	Smartphone	2	10,000
1003	Dhwani	Headphone	1	1,500

Note: The table contains many more records than shown here.

Write the following queries:

1. To display the total Quantity for each Product, excluding Products with total Quantity less than 5.
2. To display the orders table sorted by total price in descending order.
3. To display the distinct customer names from the Orders table.
4. Display the sum of Price of all the orders for which the quantity is null. 

Answer 1

1. select Product, sum(Quantity) from orders group by product having sum(Quantity)>=5;
2. select * from orders order by Price desc;
3. select distinct C_Name from orders;
4. select sum(price) as total_price from orders where Quantity IS NULL;