pity the following query, and transform it into an optimized operator tree using the restructuring algorithm, where select and proiect operations are app as soon as possible to reduce the size of intermediate relations. SELECT ENAME, PNAME FROM EMP, ASG, PROJ WHERE (DUR > 12 OR RESP = "Analyst") AND EMP.ENO = ASG.ENO AND (TITLE = "Elect. Eng." OR ASG.PNO 12 OR RESP NOT="Analyst") AND ASG.PNO = PROJ.PNO