Task 3- Views 1. Write a SQL statement to find the 'Comedy' films with the longest running time. Your query should output the names and lengths of the films. 2. Write a SQL statement to create a (virtual) view that contains all the actors that have acted in the films that you obtained in Task 3.1. The view should include the columns actor id, first name and last name. Note: Actors may act in multiple films, but should only appear once in the view 3. Write a SQL statement to create a (virtual) view called V COMEDY ACTORS 2008 that lists the ids, first names and last names of any