Consider the following SQL Query:

SELECT FNAME, DNAME

FROM EMP ASN E, DEPT AS D

WHERE E.DNO = D.DNUMBER AND D.DNAME =CCI AND SALARY > 15000;

a) Draw the initial query tree for the above SQL query

b) Show how the query tree is optimized by applying the Heuristic Rules. (You need to show the tree after applying a rule).

[ Please provide a hand drawing ]