Write a query to display Product_class_code, Product_class_description, Count of Product type in each productclass, Inventory Value (p

Communications Feb 27, 2023

Write a query to display Product_class_code, Product_class_description, Count of Product type in each productclass, Inventory Value (p.product_quantity_avail*p.product_price). Information should be displayed for only those product_class_code which have more than 1,00,000. Inventory Value. Sort the output with respect to decreasing value of Inventory_Value. [NOTE: TABLES to be used - PRODUCT_CLASS, PRODUCT_CLASS_CODE]