Use this SQL database for the question:

this questions listed as "computer science" doesnt have to be only on operating systems

actor 18 18 act id mov_id role integer integer char (30) genres 7 act id act fname actiname act gender integer char (20) char (20) char (1) 9 gen id gen title integer char (20) movie director y dirid movid integer integer char (20) char (20) dir fname dir name movid integer mov title char (50) mov year integer mov time Integer mov lang char (50) mov dt rel date mov rel country char (5) gend integer reviewer movie_direction dir d Tey id rey id mavid Integer integer rev stars integer num o ratings integer 81 integer integer integer mov id rev name chat 30 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.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