---
tags: databases,postgresql,movies,practical
---

# Movies Practical

## Setup a MoviesDB PostgreSQL Container

Please follow the instructions on here:
- [MoviesDB for PostgreSQL](https://github.com/CommandShiftHQ/be-moviesdb-postgres)

---

## Solve these challenges

Having setup your Movies container, have a go at solving these challanges:

1. Show a list of all `movies` titles
1. How many `genres` are there in the database?
1. Which movie made **the highest** revenue?
1. Show a list of movies where runtime is over **200 mins**
1. Show a list of movies that had the **top 10 biggest budgets**
1. How many **languages** are there in the database?
1. Show a list of **all the characters** in Star Wars
1. List all of `Johnny Depps` characters
1. What genre(s) are the Star Wars movies?
1. How many people played the role of `Test Site Technician` in `Spider-Man 3`?

## Entity Relationship Diagram
Here is an ERD (entity relationship diagram) so you can see how the tables in Northwind all relate to each other: