Skip to content
Untitled workspace
DataFrameas
df
variable
-- Select the product details, quantity, and location of bicycles in stock
SELECT
product_name,
category_name,
list_price,
quantity,
store_id
FROM products
INNER JOIN stocks ON products.product_id = stocks.product_id
INNER JOIN categories ON products.category_id = categories.category_id
ORDER BY product_nameDataFrameas
df1
variable
--SELECT * FROM production.brands
SELECT * FROM sales.orders