Studio

Getting Started

In Azure Data Studio, click on the File » Open File… and navigate to SQL-Part-4-Studio.ipynb you downloaded from canvas.

In Your Notebook

For this studio, you will be working in small groups and using BooksDB. One group member should screen share while fellow group members code along in their own notebooks. Each group member will submit a link to their studio notebook.

You are back at the bookstore helping employees with their inventory of books. Four employees need your help with finding books to create in-store displays. Read their requests and decide if you want to use a correlated subquery, nested subquery, UNION operator, EXCEPT operator, or INTERSECT operator. You may not use any joins or add multiple statements to the WHERE clause unless explicitly asked.

Submitting Your Work

When finished, upload your completed document to canvas!