2. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. a. List all the actors who have not acted in any movie between 1990 and 2000. b. Find how many movies are there in each genre. C. Consider the following four queries specified on Movie database: SELECT A.act_Iname FROM actor A, movie_cast C, movie M WHERE M.mov_title = 'Titanic' AND M.mov_id = c.mov_id AND A.act_id = C.act_id AND A.act_gender = 'M' COP-4722 Survey of Database Systems Assignment #1 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 (Ch 19, Textbook) c.2. Moving SELECT operations down to the query tree. c.3. Applying the more restrictive SELECT operation first