## HorrorMovies

id | Title | DirectorName | ReleaseYear | Budget | BoxOffice
--- | --- | --- | --- | --- | ---
1 | The Exorcist | William Friedkin | 1973 | 20 million USD | Medium
2 | Hereditary | Ari Aster | 2018 | 6 million USD | Medium
3 | Get Out | Jordan Peele | 2017 | 4 million USD | Medium
4 | A Nightmare on Elm Street | Wes Craven | 1984 | 1 million USD | Medium
5 | It Follows | David Robert Mitchell | 2014 | 2 million USD | Medium

## ThrillerMovies

id | Title | DirectorName | ReleaseYear | Budget | CriticRating
--- | --- | --- | --- | --- | ---
1 | Gone Girl | David Fincher | 2014 | 60 million USD | 3.0
2 | Argo | Ben Affleck | 2012 | 44 million USD | 3.0
3 | The Silence of the Lambs | Jonathan Demme | 1991 | 20 million USD | 3.0
4 | Fight Club | David Fincher | 1999 | 60 million USD | 3.0
5 | Zodiac | David Fincher | 2007 | 70 million USD | 3.0

## Actors

id | Name | BirthDate | Nationality
--- | --- | --- | ---
1 | Ellen Burstyn | Dec 7, 1932 | USA
2 | Kathy Bates | June 28, 1948 | USA
3 | Liv Tyler | July 1, 1977 | USA
4 | Patrick Wilson | January 26, 1973 | USA
5 | Vera Farmiga | August 6, 1973 | USA

## Roles

id | ActorId | MovieTitle | CharacterName
--- | --- | --- | ---
| (→ Actors.id) |  |
1 | 1 | The Conjuring | Carolyn Perron
2 | 2 | The Sixth Sense | Anna Crowe
3 | 3 | Insomnia | Alana Maxwell
4 | 4 | The Machinist | Steve Buscemi
5 | 5 | Downfall | Adolf Hitler

## FilmProductions

id | ProductionCompany | Location | NumberOfDaysInLocation | TotalCost
--- | --- | --- | --- | ---
1 | Paramount Pictures | London | 45 | 150 million USD
2 | Warner Bros. | New York City | 60 | 200 million USD
3 | Universal Pictures | Paris | 50 | 180 million USD
4 | 20th Century Fox | Los Angeles | 75 | 250 million USD
5 | Disney Studios | Shanghai | 60 | 220 million USD

## Cinematography

id | MovieTitle | CinematographerName | ShootingFormat | AspectRatio
--- | --- | --- | --- | ---
1 | Titanic | Russell Carpenter | Film | 2.39:1
2 | Avatar | Mauro Fiore | Digital 3-D | 2.39:1
3 | Blade Runner | Roger Deakins | Film | 2.35:1
4 | The Dark Knight | Wally Pfister | Film | 2.39:1
5 | Interstellar | Hoyte Van Hoytema | IMAX & Digital 3-D | 2.39:1