ite a SQL query for each of the following data retrieval requirements based on the database 1 in class

Subject:Computer SciencePrice:9.82 Bought3

Share With

ite a SQL query for each of the following data retrieval requirements based on the database 1 in class . To create the database on your computer, please use the script Assignment4.sql Canvas . List ID, Name , and Price for all products with price greater than the average product price . SELECT Product_ID , Product_Name , Product_PRICE FROM PRODUCT WHERE PRICE >= (SELECT AVG(Product_PRICE) FROM PRODUCT); For each product , list its ID and total quantity ordered .Products are listed in ascending order of product_id For each product , list its ID and total quantity ordered .Products are listed in ascending order of total quantity ordered . For each product , list its ID, Name and total quantity ordered .Products are listed in ascending order of product_id List name for all customers , who have placed order (s) W Each customer name appears exactly once . Customer names are sorted in ascending alphabetical order . Use equal join for this query. Implement query 5 using IN and subquery and add the requirement that the custom ers' orders have been placed after 23-OCT-2008. For each city, list number of customers from the city, who have placed order(s). Cities are listed in ascending alphabetical order. Use equal join for this query. Implement query '7 using natural join . Implement query 7 using IN and subquery. List ID for all products, which have NOT been ordered since 28-OCT-2008. Sort your results by product_id in ascending order. Use Minus for this query. List ID for all Arizona customers, who have placed order(s) since 28-OCT-2008. Sort your results by cust_id in ascending order. Use Intersect for this query. Implement query 11 using IN and subquery. List ID for all California customers and all customers who have placed order (5) since 28- OCT-2008. Sort your results by cust_id in ascending order. Use Union for this query. List ID , Name and total quantity ordered for all products with total quantity ordered greater than 10. List ID, Name and total quantity ordered for all products , which have been ordered more than 6 by Utah customers