that is the wrong answer for question 3, please help me with right query's

this is also the wrong answer for questin 1

please help me with right query's

Using the software.plans table, calculate how much revenue the company makes each day for each plan. Include columns for the plan_fd and the daily revenue amount rounded to 2 decimal places. Using the retall, orders table, pull all columns for orders where the final of. Using the retail. inventary table pull the current stock percentage out of the future stock level for the product with a produet_.1d =21. SELECT product-id, future_stock_level. current_stock_percentoge FROM retoil. Inventory WHERE product, 1d = 2t; Using the sof twate-plane tablu, calculate how inuch revenue the compeny mates each day for eich plan, include column for the planilit and the daily cerorive amosnt rounded to 2 decimal places. I. SELECI - 2. FaOM retall orders 3 WEAC final, total os total - diseount,anount a tax mount Uing the tetan -otders tabile, pull all cohurers for oiders where the final or.., ti. Wing the fetefl truentory tabile put the current Moek percentage out of the future stock lovel for the product with a ptotutt, id +2A