Skip to content
Spinner
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_name
Spinner
DataFrameas
df1
variable
--SELECT  * FROM production.brands
SELECT * FROM sales.orders