(c) Consider the following query specified on Movie database:

SELECT A.act_lname FROM actor A, movie_cast C, movie M

WHERE M.mov_title = The Dig AND M.mov_id = C.mov_id

AND A.act_id = C.act_id AND A.act_gender = M

(c.1) Draw the initial query tree of this query, then draw the resulting query trees after the applications of the following heuristic optimization query steps:

(c.2) Moving SELECT operations down to the query tree.

(c.3) Applying the more restrictive SELECT operation first.

I need help with part a-c please