Lab 1

Open Movies Database Application. This application covers the following period of time: 1914 - 1994
For this lab you will use only two sheets: Dashboard and Analysis

Answer the following questions. For this lab you only need to write a final answer.

1. Find the most productive Director in 1960's and the Director with most 5 stars movies in 1960's
2. Find the longest (3hrs+) movie/movies from 1980's with the highest rating (5 stars) and their Directors.
3. Find the Actor with the highest number of movies with lowest rating (1 star). Name one of these movies. Find the year with the maximal number of movies for this Actor.
4. Name the Actor/Actors with whom Steven Spielberg worked the most.
5. Find the most productive year for Alfred Hitchcock. Name all 5 stars movies of Alfred Hitchcock.
6. Find the total number of movies directed by Woody Allen. Usually, he directed one movie per year, but there are a few exceptional years. What are these years and how many movies he directed in each of these years.
7. Find the Director with maximal number of 5 stars movies. What was the best Decade of this Director
8. Name the Actor/Actors with whom Woody Allen worked the most. (The answer might surprise you)
9. Looking on the Chart "Number of movies over time", find the most productive year
10. Write your own question and answer it.