Using MySQL

Using MySQL

Using MySQL

EXERCISES Q. Answer the following Queries: i. Print the description and total quantity sold for each product. ii. Find the value of each product sold. ii. Calculate the average quantity sold for each client that has a maximum order value of 15000. iv. Find out the products which have been sold to Ivan. Find the names of clients who have 'CD Drive'. vi. Find the products and their quantities for the orders placed by Vandana' and 'Ivan'. vii. Select product_no, total qty_ordered for each product. viii. Select product_no, product description and qty ordered for each product. ix. Display the order number and day on which clients placed their order. Display the month and Date when the order must be delivered. V. X