Skip to content

Course Notes

Use this workspace to take notes, store code snippets, or build your own interactive cheatsheet! The datasets used in this course are available in the datasets folder.

# Import any packages you want to use here

Take Notes

Add notes here about the concepts you've learned and code cells with code you want to keep.

Add your notes here

# Add your code snippets here
Spinner
DataFrameas
df
variable
-- Select the product details and location of hardware priced over 2000 dollars
SELECT PRODUCT_NAME,
        DESCRIPTION,
        LIST_PRICE,
        WAREHOUSE_NAME
FROM PRODUCTS
  INNER JOIN INVENTORIES USING(PRODUCT_ID)
  INNER JOIN WAREHOUSES USING(WAREHOUSE_ID)
WHERE LIST_PRICE > 2000