CENGAGE MINDTAP Q Search this course Х Logical Operators | Logical Operators - Exercise #2 query.sql X + The Situation:

[answerhappygod]

1 (85.53 KiB) Viewed 549 times

2 (57.68 KiB) Viewed 549 times

3 (85.53 KiB) Viewed 549 times

CENGAGE MINDTAP Q Search this course Х Logical Operators | Logical Operators - Exercise #2 query.sql X + The Situation: ... 1 SELECT 2product_id, 3 total_on_hand-total_on_order 4 AS total inventory 5 FROM retail.inventory 6 WHERE total_on_hand <5 7 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 currently low in stock. They are curious as to what level the stock will be at for these items after the replenishment is complete. 2 SQL Viewer + Task product_id total_inventory 3 -12 0.00 out of 10.00 4 -35 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 6 -11 © 8 4 4/5 sq1101 Run
X Logical Operators - Exercise #2 = query.sql + Task 1 SELECT 2 product_id, 3 total_on_hand-total_on_order 4 AS total_inventory 5 FROM retail.inventory 6 WHERE total_on_hand <5 7 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 first column in your results. 0.00 out of 10.00 CO Not quite. Edit your query and try again! 2 SQL Viewer + Checks product_id total_inventory 3 -12 SQL Database Test Incomplete Exercise #2 Test 4 -35 6 Feedback -11 The wrong headers were returned. 8. 4
CENGAGE MINDTAP Q Search this course Х Logical Operators | Logical Operators - Exercise #2 query.sql X + The Situation: ... 1 SELECT 2product_id, 3 total_on_hand-total_on_order 4 AS total inventory 5 FROM retail.inventory 6 WHERE total_on_hand <5 7 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 currently low in stock. They are curious as to what level the stock will be at for these items after the replenishment is complete. 2 SQL Viewer + Task product_id total_inventory 3 -12 0.00 out of 10.00 4 -35 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 6 -11 © 8 4 4/5 sq1101 Run
= query.sql Logical Operators - Exercise #2 + X Not quite. Edit your query and try again! آنا | 1 SELECT product_id, 3 total_on_hand-total_on_order 4 AS total_inventory 5 FROM retail.inventory 6 WHERE total_on_hand <5 Checks SQL Database Test . Incomplete Exercise #2 Test Feedback The wrong headers were returned. Some expected rows were missing (shown in red below). Some unexpected rows were returned. 2 SQL Viewer + product_id total_inventory Expected Results 3 -12 4 -35 145 15 6 -11 147 10 © 8 4 4/5 > sql101 Run