The CEO would like the salespeople to discuss financing with customers. In order to do so, she would like you to create a query showing the impact on price for prior orders. This way, the reps can give customers a comparison with an order they have already placed. For the moment, she is considering a 5% interest rate, paid over 12 months. She would like you to leave the results as negative numbers.
The company is planning on opening up some shipping centers internationally. The previous CEO had been considering Brazil, Denmark, and Germany as potential shipping center locations, but he was working from older data. You will provide a list of total shipment value by country for the year before the current CEO started to best inform her decision making.