practice_bycicles

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

DataFrameas

df1

variable

SELECT brand_id
FROM brands;

DataFrameas

df2

variable

SELECT COUNT(brand_id) AS count_brand
FROM brands;

DataFrameas

df3

variable

SELECT COUNT (list_price) AS high_price
FROM products
WHERE list_price >= 20;

DataFrameas

df4

variable

SELECT COUNT (list_price) AS high_price
FROM products
WHERE list_price >=1000;

DataFrameas

df5

variable

SELECT
product_id,
product_name,
brand_id,
category_id,
model_year,
list_price
FROM products;

DataFrameas

df6

variable

SELECT COUNT (model_year) AS year_m, COUNT (list_price) AS price_l
FROM products	
WHERE model_year >=500;