Question 3: SQL Query(35 pts, 5 pts for each query) For the following questions, refer to the database on the past 7.000 ORDER MOUNT ORCER LIOS X.COM ORDER V CONTACT VAREACODE SYRON MATE DEOS CODE DENDO TOWN GOO ARAGE OPPONE 10. GARAGE L for each product the quantity on hand P QOH is less than the minimum Storage requirement PMING, the product needs to be re-ordered from the corresponding supplier. Compose a query find all the products at need to bere ordered from suppliers, shows the name of each product. member of units stock, the minimum requirements, and the droe been the units in stock and the minimum reuments framed Sortehabetically by product name 2. The store owner is preparing for the best cashier event and has asked for a list of cashier, showing each cashier's total number of onders Create a query Shoes each cashiers sounder of orders named Tolders easier employee and their full name. Ordie the output by the brofonden largest first From the Ordering table, we can see the unit ordering cost for each order for each product. The store owner want to know the average ordering cost for each product Compose a query that shows the average ordering cont for each product and the product's name. Sort the results shootically by producten to adjust the marketing strategy. the accounting manager wants to know which product is the best selling product. Write a query that shows the total number of sold toms and products name for each product Sort the most by the old tomt largest 5. After the the query 3 and the way the accounting manager wants to know the current profe Wite a Query to calculate you need to sum up all the profit made by invoices in the total cost from ordering and be 6. By the end the day, you need to update the inventory level port for each product by subtracting solides in indices from the contentory level Pease calculate the new inventory level and compare the minimum requirement Compose a query for each lected product show the products name new inventory level and the new difference between the sin stock and the minimum requirements framed "News 7. To perform the customerionship management, the storms to know the customer who spends its of money in our store. Composershow the Customer's name number of orders, and the total spending on the result by total spending for the number of orders