Question 1 : Use aggregate functions and GROUP BY to do the following: a) Find a list of genres and the average length of a Movie in each genre [output] MOVIEGENRE AVERAGE_GENRE_LENGTH Comedy | 132.0000 Drama | 131.7143 Film Noir | 114.5000 Horror | 116.5000 Samurai | 207.0000 Suspense | 114.0000 b) Find a list of directors, the number of Movies by that director, and the average length for their Movies [output] DIRID TOTAL_MOVIES AVG_LENGTH 1 | 2 | 114.0000 23115.0000 33127.3333 4 | 2 | 158.0000 5 | 2 | 121.0000 62159.5000 7 | 1 | 119.0000 c) Find a list of directors, the number of Movies by that director, and the average length for their Movies, but only including directors that have more than 1 Movie [output] DIRID TOTAL_MOVIES AVG_LENGTH 1 | 2 | 114.0000 23115.0000 33127.3333 42158.0000 5 | 2 | 121.0000 6 | 2 | 159.5000