PLEASE HELP FOR LOGICAL OPERATORS! 1) The Situation: BIG SPENDER ALERT! The Monday Boots Marketing team absolutely loves it when customers purchase multiple pairs of boots and spend a lot of money! Not only does it mean that customers enjoy the Monday Boots product, it also means that the Marketing team is doing their job well. They want to dig into some of these high value orders to see if there are any commonalities that they might be able to capitalize on in the future. Task Using the retail.orders table, pull a list of orders with a final total of over $1,000. In your results, include: order_id completed_at order_qty final_total

2)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. 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 first column in your results.

3) The Director of Marketing for Monday Boots wants to get back to his roots of when he was a Merchandising Associate and get his hands dirty by pouring over some individual order records! He wants to go down a list of orders and see as much detail as possible about each one. He comes to you for this data... Task Pull all rows and columns from the retail.orders table for orders that occurred on or after March 1, 2018.