Explore Westonci.ca, the leading Q&A site where experts provide accurate and helpful answers to all your questions. Our Q&A platform provides quick and trustworthy answers to your questions from experienced professionals in different areas of expertise. Get quick and reliable solutions to your questions from a community of experienced experts on our 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.