A way to showcase my solutions going through the SQL Zoo using the sqlite3
package in Python.
As I worked through 9 lessons of the SQL Zoo Tutorial, I wanted a way to showcase the different queries and SQL commands that I learned. I settled on converting the different queries to SQLite commands in Python.
All of these solutions and scripts are my own work.
The databases on which these exercises are based were obtained "manually" by querying the SQL Zoo databases for the relevant information and placing that information into the relevant .tsv files. SQL Zoo has a limit of showing only up to 50 rows of a query at a time. In the case of Lesson 6, the casting table has around 120,000 entries, so the solution is split into two files: the raw SQL queries in 06_more_join.sql
and also the Python implementation in 06_more_join.py
.
To avoid excessive copy/pasting, I wrote a simple Python script to scrape a lot of the data using the pynput
package. The script is not included in this repository as its values are specific for my monitor configuration.
This project was done as part of The Odin Project, which is why not all of the tutorials and lesosns available on SQL Zoo are included.