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 = Empl_Num 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 empl_num = cust_rep, 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 = Empl_Num 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