Short bit of code to connect to a sqlite db and run a query.
This is a database of the top 250 movies from the Internet Movie Database (IMDB). For simplicity's sake, it is not fully normalized. We will not be using this particular dataset during your onsite, but you can use it to familiarize yourself with SQLite and make sure you can access it from your preferred language.
- Make sure you have sqlite3 installed to explore sqlite db before running this code
- Read the
main.py
file - Run the
main.py
file (python main.py
)
We want you to feel prepared for the on-site. Before you arrive, be able to answer the following questions:
- What is the longest-running movie?
- What movie has the most actors?
- What is the breakdown of top movies by rating?