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$