At Westonci.ca, we make it easy to get the answers you need from a community of informed and experienced contributors. Explore thousands of questions and answers from knowledgeable experts in various fields on our Q&A platform. Discover detailed answers to your questions from a wide network of experts on our comprehensive Q&A platform.

1. Using the Product_Vendors table, list the ProductNumber, WholesalePrice, and an adjusted price if we reduced our prices by 5%. For example, if the current price is $100, the adjusted price should be $95.
2. Using the Orders table, show a list of Orders placed by each customer. Include the CustomerID , the date the order was placed and the order number; and show the list in CustomerID order with the newest (most recent) orders showing first within each customer.