Reference no: EM133310302

Logical Operators -

The Situation: An inventory replenishment is rapidly approaching for all styles of boots in the Monday Boots catalog. While it's good the stock is increasing for all items, the Merchandising team is most concerned about items that are curremly low in stock. They are curious as to what level the stock will be at for these items after the replenishment is complete.

Task:

Using the retail.inventory table, calculate what the total inventory would be for each product with 5 or less items in stock if all of the items on order were delivered immediately without any other sales taking place. The product_id for each product should be the ?rst column in your results. Want a hint?' the total_on_hand column represents the current stock level. Math is required in your query and don't name your calculated column].