Determine the total number of orders placed by each client. Display the client no and name.

2. Display the description and total quantity (QtyDisp) sold for each product related to shirts.

3. Display the order no and total amount of all the billed orders for the month of November Whose total is more than 15000. Joins

 4. Display the Product no and Description of Products which have been sold to 'Ivan Bayross' and are still in process.

5. Display the names of all the customers who have purchased trousers. 

 6. Display the products and their quantities which are to be delivered in current month. Sub Queries

 7. Display the product no, description and quantity in stock of non-moving products i.e., the products which are not being sold. 

 8. Display the names of the clients who have placed orders worth 35000 or more.

9. Display the product no, description and total quantity sold of the product which has been sold the most. 

10. Display the courseid, title and total students registered of the most popular course