Lesson 3 Math With SQL Retail.Inventory inventory_id integer product_id integer created_at timestamp last_updated_at timestamp total_on_hand integer total_on_order integer Lesson 3 Math With SQL Software.Plans plan_id Integer plan_type varchar(20) plan_length integer price integer Lesson 3 Math With SQL Retail Orders order_id integer customer_id integer completed_at timestamp Jorder_qty integer promotion_id integer total numeric(12,2) discount_amount numeric(12,2) tax_amount numeric 12,2) final_total numeric(12,2) payment_id integer refundid integer 1 -- write your query here 2 0.00 out of 10.00 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 daily revenue amount rounded to 2 decimal places. Click the checkbox above to attempt this task. Checks SQL Database Test Incomplete Exercise #1 Test > 0.00 out of 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. 10.00 Click the checkbox above to attempt this task. Checks + SQL Database Test Incomplete Exercise #2 Test SQL Viewer + Using the retail. inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21. 0.00 out of 10.00 Click the checkbox above to attempt this task. Checks SQL Database Test Incomplete Exercise #3 Test Lesson 3 Math With SQL Retail.Inventory inventory_id integer product_id integer created_at timestamp last_updated_at timestamp total_on_hand integer total_on_order integer Lesson 3 Math With SQL Software.Plans plan_id Integer plan_type varchar(20) plan_length integer price integer Lesson 3 Math With SQL Retail Orders order_id integer customer_id integer completed_at timestamp Jorder_qty integer promotion_id integer total numeric(12,2) discount_amount numeric(12,2) tax_amount numeric 12,2) final_total numeric(12,2) payment_id integer refundid integer 1 -- write your query here 2 0.00 out of 10.00 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 daily revenue amount rounded to 2 decimal places. Click the checkbox above to attempt this task. Checks SQL Database Test Incomplete Exercise #1 Test > 0.00 out of 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. 10.00 Click the checkbox above to attempt this task. Checks + SQL Database Test Incomplete Exercise #2 Test SQL Viewer + Using the retail. inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21. 0.00 out of 10.00 Click the checkbox above to attempt this task. Checks SQL Database Test Incomplete Exercise #3 Test
