Display Product Id (obtained by replacing ‘PR’ into ‘Product ’ of ProductId), Product Name (obtained from product name in uppercase format), MaterialName, and Average Product Purchased (obtained from average quantity of product purchased) for product which price is more than 20000 and Average Product Purchased is greater than average of all sales transaction quantity.
Display DistributorName, Distributor Phone (obtained from replace ‘08’ to ‘+628’ on DistributorPhone), DistributorAddress, and PurchaseDate for every distributor whose handle purchase transaction with the most variant product in a purchase transaction.
Can you give me the query to answer this please?
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!