18 18 movie_cast act_id mov_id role integer integer char (30) actor act_id act_fname act_Iname act_gender integer char (20) char (20) char (1) genres Y gen_id gen_title integer char (20) movie director dir_id dir_frame dir_lname integer char (20) char (20) Ymovid integer mov title char (50) mov_ year integer mov_time integer mov_lang char (50) mov_dt_rel date mov_rel_country char (5) movie_genres mov_id gen_id integer integer rating reviewer movie_direction dir_id mov_id integer rev_id integer rev_stars integer num_o_ratings integer integer integer 18 18 y rev_id rev_name integer char (30) mov_id 1. Write the SQL queries for the following items, considering the SQL Optimization Techniques studied in classes. a. Retrieve the name and year of the movies. b. Retrieve title and language of all the English movies which were released before 1998. C. Retrieve a list of first and last names of all the actors who were cast in the movie "Titanic" and the roles they played in that production