CS 443 - Assignment 10 1) Use query tree to optimize the following query. Use the tables that was provided in previous Assignment SELECT Order_Num, Amount, Company, Name, City FROM Orders, Customers, Salesreps, Offices WHERE Cust = Cust_Num AND Cust Rep = Emplum AND Rep_Office = Office AND Amount > 10000 2) Use query tree to optimize the following query. Use the tables that was provided in previous assignment SELECT cust_num, cust rep, name, rep_office, city FROM Customers, Salesreps, Offices WHERE emplnualnap, and rep_office = office AND credit limit >= 5000 And region = "western" And office in (11, 12) 3) Use query tree to optimize the following query. Use the tables that was provided in previous assignment SELECT Order_Num, Name, City FROM Orders, Customers, Salesreps, Offices WHERE Cust = Cust_Num AND Cust Rep = EmpleNum AND Rep_Office = Office AND Amount > 10000 AND region = "Western" 4) Use query tree to optimize the following query. Use the tables that was provided in previous assignment SELECT order_num, mfr, product, rep, price From orders, products Where price > 100 And Qty-On-hand > 3 and mfr = mfr_id and product = product id