Best+Film+Oscars

Download the Best Picture Oscars database which stores details of the films which won an Oscar for the Best Picture from 1980 onwards. Use the database to answer the following questions:



1. Which film won the Oscar for best film in 2005? 2. Which film won the Oscar for best film in 1987? 3. Which film won the Oscar for best film in 1993? 4. Which film won the 68th best film Oscar? 5. Which film won the 81st best film Oscar?
 * Searching**

6. Which film won the 64th best film Oscar? 7. Which films in the database are of the Mystery & Suspense genre? 8. Which films in the database are of the Comedy genre? 9. Which films in the database are of the Musical genre? 10. How many films in the database are of the Drama genre?

11. Which Oscar winners were produced by DreamWorks? 12. Which Oscar winners were produced by Miramax? 13. Which film was directed by Kathryn Bigelow? 14. Which film was directed by Oliver Stone? 15. How many best film Oscar winners have been directed by Clint Eastwood?

16. Which best film Oscar winners has Russell Crowe appeard in? 17. Which best film Oscar winners has Willem Dafoe appeard in? 18. Which best film Oscar winners has Woody Harrelson appeard in? 19. Which best film Oscar winners has Leonardo DiCaprio appeard in? 20. Which film has a rating of 83?

21. Which films have a rating of 91? 22. Which films have a rating of more than 95? (Hint: Use >) 23. Which films have a rating of less than 75?

24. Sort the database by Genre. Describe what happens. 25. Sort the database by Rating (ascending). Describe what happens. 26. Sort the database by Rating (descending). Describe what happens. 27. Sort the database alphabetically by film name. 28. Sort the database by Rating (ascending), and then on a second level by year. Describe what happens when films have the same rating (Hint: look at films with a rating of 88
 * Sorting**

29. Research and add the Best Picture winners from 2013 onwards
 * Adding records**