Create mySQL database query: 1. List all actors first and last names and their roles which start with the letter P. 2. Return all the director information for the movie Fargo. [Hint, multiple joins needed] 3. List all directors and movie year for movies released in 2000 or after .

CS-248 Query Tiny IMDB Database SQL Query: d movies id id SELECT* FROM Movies movie id movie id movie id roles movies_genresmovies_directors actor id director id id id director id actors directors_genresid ResetSubmit Query Tiny IMDB Database Table Names Actors Directors Fields (columns) References id, first_name, last_name, gender na id, first name, last name na directors_genres director_id, genre, prob Movies Movies_Directors director_id, movie_id Movies_Genres movie_id, genre Roles director_id references Directors.id id, name, year, rank na director_id references Directors.id, movie_id references Movies.id movie id references Movies.id actor_id references Actors.id, movie_id references Movies.id actor_id, movie_id, role