Answering Business Questions using SQL for Chinook Online Record Store

Hello, this is my second time sharing a notebook and I appreciate any feedback. I tried to incorporate some of the feedback from my first project. I finally feel comfortable writing SQL queries and subqueries and thinking in terms of layered tables. I was able to write all the queries without peeking at the solutions notebook, haha It was good to be able to ask my own questions and immediately write queries to explore further.

I also made sure to play a little bit with pandas and visualization - I am looking forward to practicing more so it feel a little more natural.

If I were to invest more time into this notebook, I would update the markdown and improve general readability. A table of contents would probably be helpful. I should probably write a conclusion section as well.

SQL_Answering_Business_Questions.ipynb (543.4 KB)

Click here to view the jupyter notebook file in a new tab