Please answer these.

The Situation: The Accounting team for the SaaS company is beginning to start in on some revenue recognition. As part of this process, they need to know how much each customer is paying them on a per day basis. The amount is going to be different for each of the four plans that they offer. Task > Using the software.plans table, calculate how much revenue the company makes each day for each plan. Include columns for the plan_id and the dalo revenue amount rounded to 2 decimal places. The Situation: Monday Boots implemented a new tax processing system in mid-July 2017, and with most implementations of new systems, there were a few hiccups. Some orders calculated tax correctly, but the final order total wasn't correct... Task Using the retail orders table, pull all columns for orders where the final order amount is not correct. Refer back to the structure of the retail orders table if necessary The Situation: A member of the Merchandising team for Monday Boots is expecting a shipment of additional items for one specific product. She wants to see what percentage of the future inventory level for that product is currently in stock. The current level of inventory is represented in the retail.inventory table by the total on_hand column, while the number of items included in upcoming shipments is represented by the total_on_order column. Combining those two columns would give you the future inventory level. Task > Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21 . The Situation: The Accounting team for the SaaS company is beginning to start in on some revenue recognition. As part of this process, they need to know how much each customer is paying them on a per day basis. The amount is going to be different for each of the four plans that they offer. Task > Using the software.plans table, calculate how much revenue the company makes each day for each plan. Include columns for the plan_id and the dalo revenue amount rounded to 2 decimal places. The Situation: Monday Boots implemented a new tax processing system in mid-July 2017, and with most implementations of new systems, there were a few hiccups. Some orders calculated tax correctly, but the final order total wasn't correct... Task Using the retail orders table, pull all columns for orders where the final order amount is not correct. Refer back to the structure of the retail orders table if necessary The Situation: A member of the Merchandising team for Monday Boots is expecting a shipment of additional items for one specific product. She wants to see what percentage of the future inventory level for that product is currently in stock. The current level of inventory is represented in the retail.inventory table by the total on_hand column, while the number of items included in upcoming shipments is represented by the total_on_order column. Combining those two columns would give you the future inventory level. Task > Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21