Question: Task # 0 3 : Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a
Task #: Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a productid
Want a hint?
The percentage can be calculated by dividing the current inventory level by the current inventory level plus the total number of items shipping in the future. Remember your math and the order of operations.
Want another hint?
You will need to multiply one of the fields in your calculation by to allow there to be decimal values in your answer. Try running your query without doing so to see what result you get.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
