Need to create SQL Queries for the following

1. Return all the director information for the movie Fargo. [Hint, multiple joins needed]

2. list all directors and movie year for movies released in 2000 or after.

3. List all roles (plus actors first and last name) played by actors with first name Kevin where the movies are in the drama genre.

4. List all actors and their roles for each comedy genre movie in the database.

Below is an image of the database used (attempted number one int screenshot.)