Hi I need help with question 2b please

18 18 movie_cast act id mov id role integer integer char (30) actor Y act id act frame act Iname act_gender integer char (20) char (20) char(1) genres ygen_id gen_title integer char (20) director Y dir_id dir_fname dir_iname movie_gerves mov id movie Ymov id integer mov_title char (50) mov year integer mov_time movlang char (50) mov dtrel date movral country char (6) integer char (20) char (20) integer integer integer gen_id movie_direction rating Integer integer rev stars integer num_o_rating Integer movid revid dir_id mov_id reviewer Provid rev name integer integer 81 Integer char (30) Question 1. Write the SQL queries for the following items, considering the SQL Query Optimization Techniques studied in classes. (a) Retrieve the name and year of the movies. (b) Retrieve title and language of all the Canada release country movies which were released between Jan 01/2020 and December/31/2021. () Retrieve a list of first, last names and gender of all the actors who were cast in the movie "The Dig" and the roles they played in that production Question 2. Write the SQL queries for the following items, considering the SQL Query Optimization Techniques studied in classes. (a) List all the actors who have not acted in any movie between 2015 and 2020. (b) Find how many movies are there in each genre