HW8: Database queries

Skim through the W3School intro on SQL Links to an external site., concentrating on select statements (see the list of topics in the sidebar on the left). Use this and the SQLite documentation Links to an external site. as references as you go about doing the assignment below.

Download the hw08-database-queries.ipynb notebook from the course GitHub page and put it in the notebook directory of your  CSC440 git repository (download chinook-erd.png, too, if you want the ERD to display in the first cell). Download the Chinook_Sqlite.sqlite database from the course pcloud folder.  Complete the questions in the notebook and upload your completed copy to your GitHub project. Submit a link to the notebook here.

When doing these, I'm looking for a good effort, not necessarily the exact right answer. Don't short change yourselves by just trying random things—putting in the time to really give this a good go will pay off in the long run, even if you don't get the exact right answer. Make sure you attempt both questions and that your attempts involve the components asked for in the question. You may work on this with others in the class.