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

0.00 out of 10.00

Using the retail.inventory table, pull the current stock percentage out of the future stock level for the product with a product_id = 21.